Highlight Help [Solved/Closed]

Report
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
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
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
DParson55
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018

That worked great. Thank you very much!
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
DParson55,

Glad to have helped you.

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