Conditional Formatting

I need to use conditional formatting to highlight the highest value in a row. The one caveat is, if the highest number is a duplicate, I only want to highlight the most recent value. 

Row 1: Dates going from most recent (Column A) to least recent (Column J)

Row 2: Values that I want to highlight highest.

If row 2 has a “tie” as the highest value, I only want the MOST RECENT value to be highlighted, not ALL instances of that value. 

 

 

By: Mitch

Leave a Reply

Your email address will not be published. Required fields are marked *