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 FormatConditionalFormatting
Formula is: =A1=""
Click the Format button
Select the style(s) desired (maybe a red fill color)
OK out

--
Biff
Microsoft Excel MVP


"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