Format Painter APPENDS Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 15 Jan 2008 12:05 GMT

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?

Signature

Thanks,
Bob

Reply to this Message

Bernard Liengme - 15 Jan 2008 16:09 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> 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?

Reply to this Message

Tyro - 15 Jan 2008 19:15 GMT

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

>I can confirm that in XL 2007 the Format Painter does append conditional
>formats
[quoted text clipped - 5 lines]
>> 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?

Reply to this Message