Excel Forum

Excel Magic Trick 421: Conditional Formatting Row with MAX or MIN Value

See how to create conditional formatting with a TRUE FALSE formula that will always highlight the row with the MIN or MAX value using the MAX or Min functions and a Mixed Cell Reference with part relative and part Absolute Cell Reference.

Got a Question? Ask it Here in the Forum.