Groups > microsoft.public.excel.programming > #108647

Copying down conditional formatting alone

From	Walter Briscoe <wbriscoe@nospam.demon.co.uk>
Newsgroups	microsoft.public.excel.programming
Subject	Copying down conditional formatting alone
Date	2016-03-17 17:36 +0000
Organization	A noiseless patient Spider
Message-ID	<dPel5tIrsu6WFwRM@freenetname.co.uk> (permalink)

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Copying down conditional formatting alone Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-03-17 17:36 +0000
  Re: Copying down conditional formatting alone Claus Busch <claus_busch@t-online.de> - 2016-03-17 19:19 +0100
    Re: Copying down conditional formatting alone Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-03-17 21:37 +0000

csiph-web