Joseph.Marro
Board Regular
- Joined
- Nov 24, 2008
- Messages
- 153
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Does anyone have a method of listing the conditional formatting rules applied to a workbook? I found a script that exports them to a text file but it doesn't identify the .xls file or the tab they came from. I want to be able to run the macro and have it produce a tab or new file that contains the rules applied by cell address, including the formulas used and formats selected. Any help on this would be greatly appreciated.<o></o>
<o></o>
Thank you,<o></o>
<o></o>
Joseph Marro<o></o>
<o></o>
Does anyone have a method of listing the conditional formatting rules applied to a workbook? I found a script that exports them to a text file but it doesn't identify the .xls file or the tab they came from. I want to be able to run the macro and have it produce a tab or new file that contains the rules applied by cell address, including the formulas used and formats selected. Any help on this would be greatly appreciated.<o></o>
<o></o>
Thank you,<o></o>
<o></o>
Joseph Marro<o></o>