Exporting conditional formatting rules
From within Excel 2007, can I export a set of conditional formatting rules
and then import them into another worksheet?
On Sheet "A" I've got about 12 conditional formatting rules. The rules
color certain cells based on whether a certain string of text is in the cell,
ex: HToH. I'd like for the same results in color change in the cell to
appear on Sheet "B".
I don't want to have to create the rules all over again for each sheet. The
thought of needing to edit the rules in future would be terrifying.
Thanks,
Chadwill
|