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

Hi Walter,

Am Thu, 17 Mar 2016 17:36:43 +0000 schrieb Walter Briscoe:

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.

select a cell with the conditional formatting = Conditional Formatting.
In that dialog you can change the rule and the range it is applied to.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

In message of Thu, 17 Mar 2016 19:19:33 in
microsoft.public.excel.programming, Claus Busch <claus_busch@t-
online.de writes
Hi Walter,

Am Thu, 17 Mar 2016 17:36:43 +0000 schrieb Walter Briscoe:

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.

select a cell with the conditional formatting = Conditional Formatting.
In that dialog you can change the rule and the range it is applied to.

Thanks, Claus.
I do not recognise what you write.
I found that I could select a range and change the conditional
formatting of its first cell. The change was copied through.
--
Walter Briscoe