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.