Highlight Help

DarickParson - Feb 14, 2018 at 01:05 PM - Latest reply: Mazzaropi 1745 Posts Monday August 16, 2010Registration dateContributorStatus February 20, 2018 Last seen
- 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!
See more 

3 replies

Reply to this topic
Mazzaropi 1745 Posts Monday August 16, 2010Registration dateContributorStatus February 20, 2018 Last seen - Feb 14, 2018 at 02:35 PM
0
Helpful
1
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 5 Posts Friday January 5, 2018Registration date February 14, 2018 Last seen - Feb 14, 2018 at 03:43 PM
That worked great. Thank you very much!
Respond to Mazzaropi
Mazzaropi 1745 Posts Monday August 16, 2010Registration dateContributorStatus February 20, 2018 Last seen - Feb 14, 2018 at 03:51 PM
0
Helpful
DParson55,

Glad to have helped you.

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