The conditional formatting rules will not display the same results when you use these PivotTables in earlier versions of Excel. Some PivotTables in this workbook contain conditional formatting that may not function correctly in earlier versions of Excel. 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. What it means In Excel 97-2003, you will not see conditional formatting in nonadjacent cells. This is not supported in earlier versions of Excel. One or more cells in this workbook contain a conditional formatting type on a nonadjacent range (such as top/bottom N, top/bottom N%, above/below average, or above/below standard deviation). What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting with the Stop if True option cleared, and then click Fix to resolve the compatibility issue. Conditional formatting is no longer applied after the first condition is true. What it means In Excel 97-2003, conditional formatting without stopping when the condition has been met is not an option. Earlier versions of Excel do not recognize this option and will stop after the first true condition. Some cells contain conditional formatting with the Stop if True option cleared. What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting types that are new in Excel 2016, and then make the necessary changes to use only formatting types that are supported in the earlier versions of Excel. What it means In Excel 97-2003, you will not see conditional formatting types, such as data bars, color scales, icon sets, top or bottom ranked values, above or below average values, unique or duplicate values, and table column comparison to determine which cells to format. One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets. What to do In the Compatibility Checker, click Find to locate cells that have overlapping conditional formatting ranges, and then make the necessary changes to avoid overlap. What it means Overlapping conditional formatting ranges are not supported in Excel 97-2003, and the conditional formatting is not displayed as expected. The overlapping cells will show different conditional formatting. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells.
![mac outlook conditional formatting mac outlook conditional formatting](https://i2.wp.com/joannecklein.com/wp-content/uploads/2019/04/Header-image-2.png)
Some cells have overlapping conditional formatting ranges.
![mac outlook conditional formatting mac outlook conditional formatting](https://www.codetwo.com/media/images/esig365-outlook-sign-preview1.png)
What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting applied that use more than three conditions, and then make the necessary changes to use no more than three conditions. However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excel 2016 or 2013, unless the rules were edited in Excel 97-2003. What it means In Excel 20, conditional formatting can contain up to sixty-four conditions, but in Excel 97-2003, you will see the first three conditions only. Only the first three conditions will be displayed in earlier versions of Excel. Some cells have more conditional formats than are supported by the selected file format. Issues that cause a minor loss of fidelity Issues that cause a significant loss of functionality Issues that cause a significant loss of functionality Issues that cause a minor loss of fidelity might or might not have to be resolved before you continue saving the workbook-data or functionality is not lost, but the workbook might not look or work exactly the same way when you open it in an earlier version of Microsoft Excel. 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.