View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric_NY Eric_NY is offline
external usenet poster
 
Posts: 58
Default Conditional formatting - check for blank cell

In Excel 2003, I'd like to apply colored shading to a cell if it's blank.

I select:
Cell Value Is
equal to
""

When I check it, the value box contains:
="""""" (6 quotation marks)

I can edit the value so it reads:
="" (2 quotation marks)

and that works.

But there's got to be an easier way to enter a conditional format to check
for a blank cell. Any suggestions?

Thanks.