Copying Conditional Formatting Rules

[gaming_mouse]

is it possible to export the conditional formating rules from one worksheet to another? How about apply them to all worksheets in a document?

I just want to avoid retyping the same cond. formatting rules for every worksheet in my document.

Thanks,
gm

 

[just_jon]

You can highlight the range of cells on Sheet1 and copy/paste them to your other sheets as-is, or via Copy / Paste Special / Formats.

 

[mdavidge]

Hello,

Have you tried to copy the area with the formatting and Past Special > Formats?

Mike