Conditional formatting - check for blank cell

[Eric_NY]

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.

 

[Max]

Not sure whether this is "easier", but you could always select the range, eg
select A1:E10 (with A1 active), then apply CF using Formula Is:
=ISBLANK(A1)
Format to taste > ok out

aha? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Gord Dibben]

Format>CF>Formula is: =ISBLANK(cellref)


Gord Dibben MS Excel MVP

 

[Eric_NY]

Thanks to you both.

Format>CF>Formula is: =ISBLANK(cellref)


Gord Dibben MS Excel MVP