Applying conditional formatting to multiple cells

Closed
AndieArbeit
Posts
1
Registration date
Wednesday December 11, 2013
Status
Member
Last seen
December 11, 2013
- Dec 11, 2013 at 04:09 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Dec 19, 2013 at 11:24 AM
Hi all,

I've actualy already done what I needed to do, but as this is a very sensitive document I would like to know WHY it worked, just to be sure it will remain functional when used over and over...

I have a column of percentages and created three conditions in the conditional formatting rules to show if the percentage is according to our standards:

If C2 is smaller than 72%, E2 will turn red =C2<72%
If C2 is between 73% and 91%, E2 will turn orange =AND(C2<91%,C2>73%)
If C2 is larger than 91%, E2 will turn green =C2>91%

I've copied this to all other lines below using the Format painter and it works perfectly on every cell.

How ever, if I select a cell lower down (for example E16) and look at the specific conditional formatting for that cell, the formulas remain the same. In the formulas, it still says they're based on the first line (C2). However, the resulting color formatting does match cell E16, as it should.

How does this work?

Thanks in advance for your help!

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Dec 19, 2013 at 11:24 AM
Hi AndyArbeit,

I guess that is just the way Excel shows CF rules in the more recent versions.

But what happens when the percentage is 72, 73, 91???

Best regards,
Trowa
0