Highlight Help

Solved/Closed
DarickParson - Feb 14, 2018 at 01:05 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 14, 2018 at 03:51 PM
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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 14, 2018 at 02:35 PM
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
0
DParson55 Posts 5 Registration date Friday January 5, 2018 Status Member Last seen February 14, 2018
Feb 14, 2018 at 03:43 PM
That worked great. Thank you very much!
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 14, 2018 at 03:51 PM
DParson55,

Glad to have helped you.

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