I have some Excel 2003 documents.
All cells have 3 Conditional Formatting rules.
The same Conditional Formatting rules apply to all cells.
Each rule is a Formula Is rule.
I want to change those rules.

Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
copies the conditional formatting and also copies other formatting
options such as font, etc.

Can someone please suggest an easy way to do this?
I could write a macro to do so, but that seems excessive.
--
Walter Briscoe