Conditional formatting not updating 2016
But when used inside conditional formatting, they don’t.
In Figure 3, the array formula successfully highlights the 30 in row 5 instead of the zeroes in B5 and C5.
Notice, however, that the zero values are effectively hidden from the chart because they are, in fact, zero values; thus, the chart gives the impression of applying conditional formatting to maximum and minimum values in column B.
As the data in column B changes, the results of the formulas in columns C, D, and E also change.
As these data values change, the chart appears to apply conditional formatting, when in reality, it is not doing so.
Charting is a terrific way of enhancing the readability and understandability of the data on which you report.