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 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.