#N/A conditional formatting

  • Thread starter Thread starter Pete
  • Start date Start date
P

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
 
Hi
just enter the formula
=NA()
in the conditional format dialog and choose your color
 
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)
 
Back
Top