Conditional formatting across 3 fields (with #N/A)

[DashboardNovice]

In the attached file, I want a red highlight to appear across columns B:D if all 3 values do not match. So if only one column does not equal the other two, there should be a red highlight on that row.

For some reason, the #N/A error is being ignored. On row 4, since #N/A does not equal $294.70, I would like for this for to be highlighted in red as well.

Why is the conditional formatting ignoring the #N/A. Cell F4 shows my conditional formatting formula.

 

[NARAYANK991]

Hi ,

Error values will always result in an error value when ever they are used in any arithmetic or logical operation.

Thus , when ever any of the values in columns B , C or D is an error value , the end result of the CF formula will be an error value. CF formatting rules work only when the result is a TRUE value.

See the attached file for a straightforward formula , which may be lengthy , but implements the required logic.

Narayan