orbsplateau
New Member
- Joined
- Dec 3, 2010
- Messages
- 2
version:
Excel 2007 (12.0.4518.1014)
Windows 7 Ultimate, 32-bit
Hi,
I have a worksheet with 7 conditional formatting rules. Some use relative, others use absolute references; 2 of them overlap.
When I duplicate the worksheet however, the rule precedence order gets mixed up. Copying all the cells and pasting the formatting to the new sheet doesn’t help either. I end-up with duplicate conditional formatting rules in the wrong order.
Moving the sheet to a new file/worsheet has the same effect.
I created a new sheet and re-entered the conditional formatting rules manually. By default, the newest rule applies first. I did not change the default order, but again, when I copied or duplicated the sheet, the order changed.
I tried creating a macro to do the copying and pasting, but again, the rule order changes.
Has anyone else encountered this bug? Is there something that I’m missing?
I have to duplicate this sheet once or twice a day (it’s a template). Re-sorting the conditional formatting rules every time is getting very annoying.
Any ideas?
Excel 2007 (12.0.4518.1014)
Windows 7 Ultimate, 32-bit
Hi,
I have a worksheet with 7 conditional formatting rules. Some use relative, others use absolute references; 2 of them overlap.
When I duplicate the worksheet however, the rule precedence order gets mixed up. Copying all the cells and pasting the formatting to the new sheet doesn’t help either. I end-up with duplicate conditional formatting rules in the wrong order.
Moving the sheet to a new file/worsheet has the same effect.
I created a new sheet and re-entered the conditional formatting rules manually. By default, the newest rule applies first. I did not change the default order, but again, when I copied or duplicated the sheet, the order changed.
I tried creating a macro to do the copying and pasting, but again, the rule order changes.
Has anyone else encountered this bug? Is there something that I’m missing?
I have to duplicate this sheet once or twice a day (it’s a template). Re-sorting the conditional formatting rules every time is getting very annoying.
Any ideas?