ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compatibility Mode Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/202137-compatibility-mode-conditional-formatting.html)

Bliss

Compatibility Mode Conditional Formatting
 
Having trouble with conditional formats with compatibility mode. I know only
3 apply if the sheet is to be used with 01/03, so I have three color-coding
conditions, but also some of my formulas are folded into ISERROR formulas.
Does Excel count an ISERROR formula as one of the three conditional formats
in compatibility mode?


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com