Help with Conditional Formatting
 

I am trying to do conditional formatting of a few cells. The condition is:
Cell Value = #N/A
and the format is to assign the background color to the font. But for some
reason it doesn't work. The cells doesn't change.
Any ideas what I'm doing wrong here?
Thanks

Help with Conditional Formatting
 

Hi,

Use

=ISNA(a1)

wher a1 is the cell you are Conditionally formatting
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Ayo" wrote:

I am trying to do conditional formatting of a few cells. The condition is:
Cell Value = #N/A
and the format is to assign the background color to the font. But for some
reason it doesn't work. The cells doesn't change.
Any ideas what I'm doing wrong here?
Thanks

Help with Conditional Formatting
 

Thanks Mike.

"Mike H" wrote:

Hi,

Use

=ISNA(a1)

wher a1 is the cell you are Conditionally formatting
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Ayo" wrote:

I am trying to do conditional formatting of a few cells. The condition is:
Cell Value = #N/A
and the format is to assign the background color to the font. But for some
reason it doesn't work. The cells doesn't change.
Any ideas what I'm doing wrong here?
Thanks