Excel Forum
Similar Content
MAX and MIN Values from a Filtered List in Excel
Tutorial: How to get the MAX and MIN values from a filtered data set. This method returns the value ...
Count the Occurrences of the Largest or Smallest Value in a Range
Tutorial: How to count the occurrence of the largest or smallest value in a range; basically, how m...
Vlookup to Return the Min, Max, or Average Value in Excel
Tutorial: Perform a Vlookup that returns the highest value, lowest value, or average value from a d...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.