Conditional formatting - check for blank cell

E

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.
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if there is a blank ,how to get the blank cell in a range be highlighted 2
Conditional formatting disappears when cell contents deleted 2
Conditional formatting based on formula cell 4
Conditional formatting for time 2
Matching literal text "???" in Word 2010 field code IF statement 2
Conditional Formatting with Calculated Blank 2
display '2+2' as '4' in a cell? 5
applying conditional formatting to emtpy cells in a spreadsheet 6

Top