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.