View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Walter Briscoe Walter Briscoe is offline
external usenet poster
 
Posts: 279
Default Copying down conditional formatting alone

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