formula in excel that will highlight a cell that is left blank
Hey Thanks Dave, worked great.
"Dave Thomas" wrote:
One way is conditional formatting. If your cell is B10, Format
menu/Conditional formatting. Under condition 1, select formula. In the box
to the right type =isblank(B10)
Then select format .... below the formula box. Then select the patterns
tab. Select the color you want the cell to be if it is blank.
..
"Kimo" wrote in message
...
I'm trying to find a formula to make a certain cell if it is left blank to
be
able to highlight it with a color. Anyone have any ideas? Thanks Kimo
|