Turn all #N/A values white in a range
 

Adam,

Use conditional formatting. Say one of the cells is b1

Format|Conditional format - formula is
enter the formula
=ISERROR(B1)
Pick a white font

OK

Then use the format painter to paint this into other cells

Mike

"Adam" wrote:

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