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.

Search for conditional formatting not updating 2016:

conditional formatting not updating 2016-2conditional formatting not updating 2016-78

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “conditional formatting not updating 2016”

  1. This process buys us another month until traffic reaches another threshold and we're runnning too many counts. We realize that we need to take a look at another datastore to hold these counts, even if for a temporary amount of time.