View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default CAN I HIGHLIGHT A CELL TO STAY HIGHLIGHTED UNTIL DATA IS ENTERED

Try this:

Assume you want to do this to cell A1
Select cell A1
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the little box on the right:

=A1=""

Click the Format button
Select the style(s) desired. Maybe a fill color from the Patterns tab?
OK out

Biff

"HHrnndz" wrote in message
...
CAN I HIGHLIGHT A CELL TO STAY HIGHLIGHTED UNTIL DATA IS ENTERED