Condition Formatting: How to highlight the most highest/lower value based on criteria

**Shermaine2010** · 07-01-2018, 03:13 AM

Criteria:-
C1: If Remark = "Short", select the highest value between Data 1 & Data 2.
C2: If Remark = "long", select the lowest value between Data 1 & Data 2.
The selected value to be highlighted in yellow color.

Thanks

**David A Coop** · 07-01-2018, 03:49 AM

This is really confusing.

You column D has cell references randomly, and they don't match your rule.

For example. In cell D2 you say to highlight C6. B6 says "Short", so according to your rule, A6 should be highlighted!

I'm obviously missing something, so explain some more.

Regards

David

**Shermaine2010** · 07-01-2018, 04:34 AM

David, you are right.
I was typo on column D.

Reupload the file. Please check again. Thanks

**FlameRetired** · 07-01-2018, 07:15 PM

With the 'Applies to:' set to non-contiguous range. =$A$2:$A$13,$C$2:$C$13

and "Use formula to determine which cells to format" use this formula for "Short"

Formula:

Please Login or Register  to view this content.

and this one for "Long"

Formula:

Please Login or Register  to view this content.

Condition Formatting: How to highlight the most highest/lower value based on criteria

LinkBack

Thread Tools

Rate This Thread

Display

Condition Formatting: How to highlight the most highest/lower value based on criteria

Re: Condition Formatting: How to highlight the most highest/lower value based on criteria

Re: Condition Formatting: How to highlight the most highest/lower value based on criteria

Re: Condition Formatting: How to highlight the most highest/lower value based on criteria

Thread Information

Users Browsing this Thread

Similar Threads

Using conditional formatting to highlight cells based on date + 1 other condition

[SOLVED] Conditional Formatting - Highlight cell based on two criteria

[SOLVED] Find Highest Value Based on Condition

[SOLVED] A conditional formatting rule that will highlight a cell based on certain criteria/date

Highlight a cell based on data in another cell - condition formatting or formula??

VBA code to find highest and 2nd highest number based in criteria

Conditional Formatting to highlight highest number in column

Bookmarks

Bookmarks

Posting Permissions