# Conditional Formatting - The Greater of 2 Cells = Green

1. ## Conditional Formatting - The Greater of 2 Cells = Green

Hi,

Comparing 2 cell values, I wish to make the greater value green.

A1=1
A2=2

A2 will be green. A1, no fill.

Easy for you. Not for me.

Thanks,

Jon

2. ## Re: Conditional Formatting - The Greater of 2 Cells = Green

Try this...

Select cells A1:A2 starting from cell A1

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=AND(A1<>"",A1=MAX(A\$1:A\$2))

Click the Format button
Select the desired style(s)
OK out

3. ## Re: Conditional Formatting - The Greater of 2 Cells = Green

Conditional formatting formula for column A: =\$A1>\$B1
Conditional formatting formula for column B: =\$B1>\$A1

Make sure the active cell in your selection is in row 1 when you apply the conditional formatting.

Let me know if you need further help implementing.

4. ## Re: Conditional Formatting - The Greater of 2 Cells = Green

Thanks, Tony and yay.

Tony, your formula did the trick...as usual! Thanks for your help...as usual!

yay, I'll have to play with your formula since it pertains to different columns. Thanks for your input.

5. ## Re: Conditional Formatting - The Greater of 2 Cells = Green

You're welcome. Thanks for the feedback!

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