View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chadwill Chadwill is offline
external usenet poster
 
Posts: 6
Default 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