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.

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.

FormatCFFormula is: =ISBLANK(cellref)


Gord Dibben MS Excel MVP

On Tue, 18 Aug 2009 07:16:01 -0700, 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.

Thanks to you both.

"Gord Dibben" wrote:

FormatCFFormula is: =ISBLANK(cellref)


Gord Dibben MS Excel MVP

On Tue, 18 Aug 2009 07:16:01 -0700, 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.