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
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
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
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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.
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.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks