View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Copying down conditional formatting alone

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