K
Keith R
I have a series of cells that I need to graph.
In order to avoid false zero values, I've used an if formula, similar to:
=if(isnumber(A2),A2,na())
now I'm going to be using this workbook with some non-computer people who
are easily confused by stuff they don't understand, such as a bunch of
cells with #N/A in them, so I want to use conditional formatting to set the
text color in those cells to white (same as background) when the value
shown in #N/A.
Unfortunately, I can't figure out what I should put in the conditional
formatting box to get this to work- cell value = ??
I've tried variations of na() and #N/A and =na and nothing seems to catch-
any suggestions?
Many thanks,
Keith R
In order to avoid false zero values, I've used an if formula, similar to:
=if(isnumber(A2),A2,na())
now I'm going to be using this workbook with some non-computer people who
are easily confused by stuff they don't understand, such as a bunch of
cells with #N/A in them, so I want to use conditional formatting to set the
text color in those cells to white (same as background) when the value
shown in #N/A.
Unfortunately, I can't figure out what I should put in the conditional
formatting box to get this to work- cell value = ??
I've tried variations of na() and #N/A and =na and nothing seems to catch-
any suggestions?
Many thanks,
Keith R