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
---
"Eric_NY" wrote:
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.