Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Answer 1 / 2
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
Report
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018
That worked great. Thank you very much!
Answer 2 / 2
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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!