Bug in Conditional Formatting

Question

Hi all... I think I have found a bug in Excel 2010 and conditional formatting.

I have a document with Conditional formatting in most sheets and when I went into Conditional Formatting Rules Management I saw they had become erratic. So I chose "This workbook" and clear away all doublicates... so I only had on left and updated the "applies to" range... so it covers the decired cells... and this worked fine.

But since I have several sheets with Formatting I decided to update the other sheets by choosing the other sheets from within the Conditional Formatting Rules Management... just as previously I deleted doublicates without problem and then I updated the rules on the one that was left.

However... when I pressed "Apply" the formula regressed back to what it was before I updated it.

I exited the manager and switched activesheet manually, reentered and chose "this worksheet"... and now I could update it.

But just as previously I then chose another sheet and tried to update formulas in that one, but the same thing happend again.

I asked a friend create a new document and create a basic Conditional Format so we could try this bug on his computer aswell... and we found the same problem again.

I will do the "long way"... but though you guys should know :-)

//F-U-S

Answer 1

Hi OssieMac.

Think you misunderstood the situation.

I'm not trying to create a Conditional formatting... only editing one that already exists.

A simple test.

Open a new workbook... and create a Conditional Format on Sheet 1.

Go to Sheet 2 and open the Conditional Format Manager and in there choose to see all formats on Sheet 1.

Change the range by a single number and try to Apply... and you'll se it doesn't work.

Answer 2

AFAIK Conditional formatting can only be applied to the one sheet.

However, you can copy the Conditional Formatted range on one sheet and then select another worksheet and select the first cell it is to be applied to and Paste Special -> Formats where it will then create the Conditional Formats on the other sheet.