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
|