Excel 2003: Conditional Formatting Woes 3

[krets]

I have a large table of data that contains some blank cells here and there. What I would like is to set the background color/pattern conditionally for any cell that is blank but I can't seem to get that done.

I've tried setting all cells to the "greyed out" pattern and then formatting with greater than or equal to zero but that does no good.

Any suggestions?

Basically I want any cell that contains nothing to have a "greyed out" look to it. The other cells might contain text and/or numbers.

 

[SkipVought]

Hi,

ISBLANK function

Skip,

_[red][/red]

 

[AnotherHiggins]

Cell Value
Equal To
=""


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[krets]

I've tried the Cell value is equal to "" option and that doesn't work.

Skip: I'm using Conditional Formatting, not a function.

 

[SkipVought]

Formula Is: =ISBLANK(A1)

Skip,

_[red][/red]

 

[AnotherHiggins]

Notice I put " ="" "

If youjust put in "" then go back in to edit, you'll see that excel has added an equals sign and wrapped your quotes in quotes. It will look like this:
[tab]=""""
So you need to put in the equals sign yourself.

Skip's suggestion will work as well.

Formula Is
=isblank(a1)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

There's more than ONE way to skin a cat! ;-)

Skip,

_[red][/red]

 

[krets]

Thanks both of you. I used Skip's suggestion that what works just fine.