Help with Conditional Formatting

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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
 
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.
 
Thanks Mike.

Mike H said:
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.
Click to expand...
 
Back
Top