#N/A conditional formatting

[Pete]

can conditional formatting be set to change the colour if
an error is returned as teh cell value. i.e. I want to
make #N/A cells be light grey
thanks
Pete

 

[JE McGimpsey]

One way:

Make your condition (for cell A1):

Formula Is =ISNA(A1)

 

[Frank Kabel]

Hi
just enter the formula
=NA()
in the conditional format dialog and choose your color

 

[Bob Phillips]

Pete,

You can test for #N/A with

=ISNA(cell))

This will return true or false, just what you need for CF.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)