Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting compatibility with excel 2003
Hi.
Have an issue with conditional formatting rules created on excel 2003 and edited by excel 2007. I created a series of rules on specific fields of a pivot table. The rules are applied to many cells on the same column, so that if the pivot table expands vertically, the new rows are affected by the same rule, too. Everything has worked perfectly for years. Now, with excel 2007, these rules are no longer kept. Excel erases all the rules applied to cells inside the pivot table and moves the rule to cells outside the table. The only solution I found so far is to re-create the rule with 2007 but other users (who read the same file using 2003 version) won't be able to read the file like before. Has anyone else encountered the same problem? Is there a work around it? Many thanks in advance. -- eml |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advice - Excel 2003 Compatibility | Excel Discussion (Misc queries) | |||
Color palette compatibility Excel 2007 vs. 2003 | Excel Discussion (Misc queries) | |||
Conditional Formatting: Excel 2003 vs. 2007 | Excel Worksheet Functions | |||
Excel 2003: Conditional Formatting | Excel Discussion (Misc queries) | |||
Excel 2003 compatibility | Excel Discussion (Misc queries) |