ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formatting backwards compatibility question (https://www.excelbanter.com/excel-worksheet-functions/270732-conditional-formatting-backwards-compatibility-question.html)

Vladimir Shchelkunov

Conditional formatting backwards compatibility question
 
Hi All

I'm having some issues with backwards compatibility of a file with
conditional formatting built in 2007.

I have a cell (M63) that has 2 conditions applied to it:
#1 - if M$3="N/A", then .....
#2 - if D$63="Yes", then....

When I save the file as a 2003 version, only the first condition is
left. If I add condition #2 in 2003 it works, however, I end up with 3
conditions if the file is open in 2007.

Is this a permanent issue due to backwards compatibility or something
could be done to fix it?

Thanks in advance
Vlad


All times are GMT +1. The time now is 08:22 AM.

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