Turn all #N/A values white in a range
 

Just a personal pet peave but iserror is overkill and potentially dangerous.
IsNA will catch only the specific error that we reasonably expect to see
here. Iserror catches everything and if a formula is corupted returning #ref
or some other problem the error will be hidden. Not to say that I never use
IsError but it is really rare. IMO IsError is overused.

Just my 2 cents...
--
HTH...

Jim Thomlinson


"Mike H" wrote:

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