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

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

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,

Tony

2. ## Re: If one cell is greater than another, change fill color of other cells. If not, no cha

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

3. ## Re: If one cell is greater than another, change fill color of other cells. If not, no cha

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

4. ## Re: If one cell is greater than another, change fill color of other cells. If not, no cha

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

5. ## Re: If one cell is greater than another, change fill color of other cells. If not, no cha

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

6. ## Re: If one cell is greater than another, change fill color of other cells. If not, no cha

Thank you very much, Have a Merry Christmas

7. ## Re: If one cell is greater than another, change fill color of other cells. If not, no cha

Merry Christmas!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1