I am interested in putting an image of a tank in an excel sheet and showing how full it is in cell A1 on the image.
This will show the user how much the tank is full.
Can anyone direct me to how I might do this??
What version of Excel are you running? I'm not sure about 2007, but in 2003 it is not possible to put a picture inside a cell. All pictures/images/shapes/whatever are placed on the sheet "in front of" the cells.
I've never tried this with a picture. You'd have to Crop it I guess.
What I can suggest that I know works, is that you put your picture of your tank, and then put a Rectangle Shape on top of it to simulate it being filled.
You can insert a picture into the comment (Select comment, right click and then Format comment/Colors and Lines/Color/Fill Effects/Picture). To control the level in a tank, though, is possible only using VBA and a few different pictures.
The other way is to use conditional formatting on a vertical range of cells representing the tank. Let say tank is 10 cells high, the value in cell "B2" represents percentage of tank filled.
The bottom cell condition ="$B$2>0" background color = blue
Sectond cell condition =$B$2>=15
......
Top (10) cell condition =$B$2>=95