formula in excel that will highlight a cell that is left blank?

[Guest]

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

 

[Dave Thomas]

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.

..

 

[T. Valko]

The cell will be highlighted until something (anything, except a formula
blank) is entered.

Assume the cell of interest is A1
Select cell A1
Goto the menu Format>Conditional>Formatting
Formula is: =A1=""
Click the Format button
Select the style(s) desired (maybe a red fill color)
OK out

 

[Guest]

Thanks for your input.

The cell will be highlighted until something (anything, except a formula
blank) is entered.

Assume the cell of interest is A1
Select cell A1
Goto the menu Format>Conditional>Formatting
Formula is: =A1=""
Click the Format button
Select the style(s) desired (maybe a red fill color)
OK out

 

[Guest]

Hey Thanks Dave, worked great.

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.

..