Excel conditional formatting not updating

Posted by / 20-Apr-2018 17:57

Excel conditional formatting not updating

Important: Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.

Conditional formatting is no longer applied after the first condition is true.

What to do In the Compatibility Checker, click Find to locate cells that contain a conditional formatting type on a nonadjacent range, and then make the necessary changes to use conditional formatting rules that are available in earlier versions of Excel.

Some Pivot Tables in this workbook contain conditional formatting that may not function correctly in earlier versions of Excel.

Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells.

The overlapping cells will show different conditional formatting.

excel conditional formatting not updating-17excel conditional formatting not updating-30excel conditional formatting not updating-13

One thought on “excel conditional formatting not updating”

  1. Still, the US Census reported that in 2014, the average age of brides was 31, and 33 for grooms. A big factor of this can be attributed to couples living together before they get married.