Hi,

I've this annoying problem in Excel 2007 that doesn't exist in 2003.

When I use Format Painter, it is appending conditional formatting rules to
the cell rather than over-writing them. How do I stop this behavior?

--
Thanks,
Bob

I can confirm that in XL 2007 the Format Painter does append conditional
formats
Not sure how you can override this but will report it to MS
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob" <86c6c2e6-2146512712@news.postalias> wrote in message
news:B97B5489-7309-4914-876E-3644ABF03742@microsoft.com...
> Hi,
>
> I've this annoying problem in Excel 2007 that doesn't exist in 2003.
>
> When I use Format Painter, it is appending conditional formatting rules to
> the cell rather than over-writing them. How do I stop this behavior?
>
> --
> Thanks,
> Bob

Format Painter and Copy/Paste in Excel 2007 add the copied conditional
formatting rules at the beginning of the rules list rather than appending
them, which implies that they are added to the end of the existing rules. So
the copied rules may take precedence over the existing rules, particularly
if Stop If True is checked..

Tyro

"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:OyCaHf6VIHA.4696@TK2MSFTNGP05.phx.gbl...
>I can confirm that in XL 2007 the Format Painter does append conditional
>formats
> Not sure how you can override this but will report it to MS
> --
> Bernard V Liengme
> Microsoft Excel MVP
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Bob" <86c6c2e6-2146512712@news.postalias> wrote in message
> news:B97B5489-7309-4914-876E-3644ABF03742@microsoft.com...
>> Hi,
>>
>> I've this annoying problem in Excel 2007 that doesn't exist in 2003.
>>
>> When I use Format Painter, it is appending conditional formatting rules
>> to the cell rather than over-writing them. How do I stop this behavior?
>>
>> --
>> Thanks,
>> Bob
>
>