Turn all #N/A values white in a range
 

Use the ISNA() function. For example, for C6, use this Conditional Format
formula...

=ISNA(C6)

--
Rick (MVP - Excel)


"Adam" wrote in message
...
Hi

Excel 2003

I want to conditonal format a range, say C6 to H59, so that the font turns
to white if the result in the cell is #N/A. The result comes from an IF
Function.

I need the N/A values to prevent them appearing in a graph as 0 values and
so can't be deleted.

Any help, much appreciated!

Cheers