Excel 2007 : Conditional Formatting - copying, pasting and editing problems

Hi,

I'm really struggling with Excel 2007 conditional formatting - I like the new features, but am very frustrated with how it is applied.

In earlier versions of Excel, I could select a single cell (or subgroup of cells) within a range that had conditional formatting, and remove it from that single cell. But it seems in Excel 2007 that if I remove conditional formatting from that one cell, it deletes it from the entire range as well.

For example, just say range A1:D10 has conditional formatting that colors the cell fill green if the value is 1. And then if I select cell C3 and try to remove the conditional formatting from that one cell by deleting the rule, the conditional formatting is removed from the entire range A1:D10, not just C3. I can get around this by going into the Applies To field and changing the range by manually selecting 4 areas surrounding that one cell. But what if I have multiple rules, or multiple non-contiguous cells from which I want to remove the conditional formatting - in earlier versions I could simply select the cells and delete the conditional formatting rules from them, but the process in Excel 2007 seems so much more complex.

And a related problem - just say I have complex conditional formatting applied to the same range (A1:D10) involving 5 rules. If I want to copy this formatting and paste it to another range (eg F1:G10) it does so. But if I want to make a slight change to the conditional formatting in the new range (F1:G10) like changing one number in the conditional format formula, the change affects both the original range and the new range. If I want the minor change to apply only to the new range, I have to change the Applies To range of the original range, and add the 5 rules manually again to the new range.

This is driving me crazy. Am I missing something? Is there a way to copy, paste and edit conditional formatting in a similar way to previous versions of Excel?

Tim

Thanks very much darkyam....

With regards to the second problem, it doesn't appear to exist any more. I tried replicating the issue at work today, but couldn't - that is, when copying and pasting the format of conditionally formatted cells to a new range, the new range seems to be independent of the original, which means I can make minor changes to the conditional formula without affecting the original range. Not sure why I thought the opposite was happening - maybe I was doing something differently. I'll try it on my home computer again when I finish work just to be sure.

Tim

Hello,

I am struggling with how to copy and paste conditional formatting to a new range of cells. Can someone explain how to do that?

Thank you!!