Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108647 > unrolled thread
| Started by | Walter Briscoe <wbriscoe@nospam.demon.co.uk> |
|---|---|
| First post | 2016-03-17 17:36 +0000 |
| Last post | 2016-03-17 21:37 +0000 |
| Articles | 3 — 2 participants |
Back to article view | Back to microsoft.public.excel.programming
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
| From | Walter Briscoe <wbriscoe@nospam.demon.co.uk> |
|---|---|
| Date | 2016-03-17 17:36 +0000 |
| Subject | Copying down conditional formatting alone |
| Message-ID | <dPel5tIrsu6WFwRM@freenetname.co.uk> |
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
[toc] | [next] | [standalone]
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Date | 2016-03-17 19:19 +0100 |
| Message-ID | <nces9q$a30$1@dont-email.me> |
| In reply to | #108647 |
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
[toc] | [prev] | [next] | [standalone]
| From | Walter Briscoe <wbriscoe@nospam.demon.co.uk> |
|---|---|
| Date | 2016-03-17 21:37 +0000 |
| Message-ID | <RjbmiYK8Ny6WFwyU@freenetname.co.uk> |
| In reply to | #108648 |
In message <nces9q$a30$1@dont-email.me> 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
[toc] | [prev] | [standalone]
Back to top | Article view | microsoft.public.excel.programming
csiph-web