I did as you instructed. But it messed that sheet up totally. All I want to
copy over is the conditional formatting RULES, not the formatting itself.

Any other ideas?

Chad
**************************

"Roger Govier" wrote:

Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
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