|
Posted to microsoft.public.excel.programming
|
|
|
Turn all #N/A values white in a range
=isna(A1)
http://www.contextures.com/xlCondFormat03.html#Errors
--
HTH...
Jim Thomlinson
"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
|