In my Excel worksheet, I have a cell containing the following formula:

```
=IF(COUNT(Y11:AA11)>0,SUM(Y11:AA11),#N/A)
```

with the goal of a chart later using the display of the cell in a graph (excluding the display of any 0 values), which it does.

The issue I have is that there are a lot of `#N/A`

display values that look messy, so I want to use conditional formatting to make the cases when `#N/A`

is displayed have white text. So far every attempt makes every value have white text regardless of if the display value is `#N/A`

or a number. Does anyone know a way to do this?

Things I have tried:

Using conditional formatting with formula condition of

`=ISERROR($X$4:$X$37)`

, applied to the range`$X$4:$X$37`

. (All cells in the range are formatted to use white text; valid numbers and error values.)Using conditional formatting with formula condition of

`=ISNA($X$4:$X$37)`

(same result).Using conditional formatting with affectation only to duplicates (Displaying number still affected)

Changing formula in the cells (

`X4:X37`

) to`=IF(COUNT(Y11:AA11)>0,SUM(Y11:AA11),"#N/A")`

, then conditional formatting that text. (Zero value now displays on graph since`"#N/A"`

is text and`#N/A`

was not.)

`#N/A`

in quotes in your formula:`=IF(COUNT(Y11:AA11)>0,SUM(Y11:AA11),"#N/A")`

`=ISERROR(A2)`

to determine which cells to format. In your example, you should use`=ISERROR(X4)`

. The point is that the argument to any of the`ISxxx()`

functions should be a single value, not a range. (I can’t even figure out … (Cont’d)`ISERROR`

documentation repeatedly says that you pass itvalue, I don’t see where it ever says that the parameter must not be a range or an array.) So try that; the Conditional Formatting mechanism takes care of handling each cell fromA`X4`

to`X37`

. And don’t usesigns. If you say`$`

`=ISERROR($X$4)`

, then the entire range will turn white if`X4`

is an error (and vice versa). … (Cont’d)3more comments