This works for highlighting the two largest numbers.
1. Add two helper columns populated using:2. Apply the following conditional formatting rule to columns G:M![]()
=IF(COUNTIFS($G6:$M6,MAX($G6:$M6))>1,AGGREGATE(15,6,(COLUMN($G6:$M6)-COLUMN($F6))/($G6:$M6=LARGE($G6:$M6,COLUMNS($BG6:BG6))),COLUMNS($BG6:BG6)),AGGREGATE(15,6,(COLUMN($G6:$M6)-COLUMN($F6))/($G6:$M6=LARGE($G6:$M6,COLUMNS($BG6:BG6))),1))
Let us know if you have any questions.![]()
=OR(COLUMNS($G6:G6)=$BG6,COLUMNS($G6:G6)=$BH6)
Bookmarks