Highlight Help [Solved/Closed]

Report
-
Posts
1894
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 6, 2021
-
Hello,

I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needing to highlight "green" whichever of those two cells contains the greater numerical value.

TIA!

2 replies

Posts
1894
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 6, 2021
142
DarickParson, Good evening.

You can use CONDITIONAL FORMATTING.

Select J2:J3

Menu Conditional Formatting --> Using Formula -->

Type: =J2=MAX($J$2:$J$3)

Choose Fill Color as desired --> OK

Please tell us if it worked as desired.

I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018

That worked great. Thank you very much!
Posts
1894
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 6, 2021
142
DParson55,

Glad to have helped you.

Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!