Conditional Format

  • Thread starter Thread starter Shona
  • Start date Start date
S

Shona

I'm sure this must be simple but I can't quite fathom it out.

I want a conditional format that puts a colour in a cell if the cell is
empty.

Any ideas would be great

Thanks Shona
 
Shona,

In the Conditional Formatting dialog, choose the 'equal to' option and enter
="" , the choose your format options.
 
Shona,

Yes, the '=' is required. Without it, CF would attempt to compare to the
literal characters "" rather than an empty string.
 
Back
Top