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.