Ask a question Report

Highlight Help [Solved]

DarickParson - Feb 14, 2018 at 01:05 PM - Latest reply: Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen

- Feb 14, 2018 at 03:51 PM

Excel Ask a question Report

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!

Highlight Help
Excel VBA - Change cell color based on value (Solved) » Forum - Programming
Macro to compare two excel sheets (Solved) » Forum - Excel
Highlight cell if another cell contains any text (Solved) » Forum - Excel
Excel - - Highlight cell if no data » How-To - Excel
Excel - Macro-Highlight if difference > or < 2 » How-To - Excel

Your reply

Reply to this topic

3 replies

Report Respond to Mazzaropi

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 14, 2018 at 02:35 PM

Helpful

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 Respond to DParson55

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!

Report Respond to Mazzaropi

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 14, 2018 at 03:51 PM

Helpful

DParson55,

Glad to have helped you.

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

Your reply

Reply to this topic

Ask a question