Conditional Formatting - The Greater of 2 Cells = Green

[ThanksAlot]

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

[Tony Valko]

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

[yay_excel]

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.

[ThanksAlot]

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.

[Tony Valko]

You're welcome. Thanks for the feedback!