ExcelBanter - Turn all #N/A values white in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Turn all #N/A values white in a range (https://www.excelbanter.com/excel-programming/430080-re-turn-all-n-values-white-range.html)

Jim Thomlinson

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

Adam

Turn all #N/A values white in a range

Thanks Jim

"Jim Thomlinson" wrote:

=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

All times are GMT +1. The time now is 06:56 PM.