Select cell range B5:I5 (where Sales Rep names are listed), use Conditional Formatting with formula to locate the SaleS Rep who has the maximum COGS. Do you remember how to use Conditional formatting with formula? In this case, you match the value in B25 amongst values in the Grand Total in Row 20, and you highlight corresponding Sales Rep name (in cell range B5:I5) in BOLD and BLUE font.