If one cell is greater than another, change fill color of other cells. If not, no change

[nighttrain20]

Hello,

In example 1 - I would like B1,C1,D1 to turn a fill color (green), if G1 is greater. than I1

In example 2 - I would like B1,C1,D1 to have no fill (stay the same) if, G1 is less than I1 or even

See attached,

Thank you in advanced,

Tony

[AliGW]

So are these rules meant to be mutually exclusive? What happens if G1 is greater than I1 AND even?

So far, two rules:

=$G1>$I1
=OR($G1<$I1,ISEVEN($G1))

[PaulM100]

Conditional formatting applied to B1:D1 with colour green and formula =$G1>$I1

[nighttrain20]

Their can only be 3 out comes:

1. G1 is greater than I1 - in that case fill color the cells green
2. G1 is less than I1 - in that case no fill
3. G1 & I1 are the same - again, no fill

Hopefully I explained that right.

Thanks,

Tony

[AliGW]

So, you don't mean even, then, but equal to. So, you need to set up three rules:

=$G1>$I1
=$G1=$I1
=$G1<$I1

EDIT: No, you don't need three rules - you just need one! The other two conditions require no fill, so no rule required.

=$G1>$I1

[nighttrain20]

Thank you very much, Have a Merry Christmas

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Merry Christmas!