Excel - Highlight Entire Row of the Record with the Largest Value Row - Episode 1207

647 views · Published 31 May 2010 · 2:29 · Indexed 1 November 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to highlight the entire row of the record with the largest value. 

Welcome back to the MrExcel netcast! In yesterday's episode, we learned how to use conditional formatting to highlight the lowest value in each row. But during a seminar, someone asked a different question - how do we highlight the entire row for the item with the highest average? In today's episode, we'll tackle this problem and show you how to use conditional formatting to highlight the largest row.

Just like yesterday, we'll pay attention to the active cell, which in this case is cell H2. We'll create a new conditional formatting rule and use a formula to determine which cells to format. This time, we'll be looking at column N of the current row. By using the formula =$N2, we can apply this formatting to each individual row. And by using the MAX function, we can compare the values in column N to find the largest value.

Once we have our formula set up, we can choose the formatting we want to apply to the largest cell. In this case, we'll go with a nice green fill. And just like that, the entire row will be highlighted for the largest value. You can test this out by entering a larger value in a different row and seeing the formatting change. This method of using formulas for conditional formatting is a powerful tool that allows us to change the color of a cell based on other cells.

In conclusion, we've learned how to highlight the largest row using conditional formatting in today's episode. This is a great tool to have in your Excel arsenal and can save you time and effort when working with large data sets. Thank you for tuning in to the MrExcel netcast, and be sure to join us next time for more helpful tips and tricks. Don't forget to check out our sponsor, MrExcel.com, for even more Excel solutions. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/



Table of Contents:
(00:00) Introduction and Sponsorship 
(00:12) Highlighting Lowest Value in Each Row 
(00:32) Creating a New Conditional Formatting Rule 
(00:42) Using a Formula to Determine Formatting 
(01:04) Applying Formatting to Entire Row 
(01:26) Testing the Formatting 
(01:46) Comparing to Previous Method 
(02:01) Power of Formatting with Formulas 
(02:12) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Active cell
Column N
Conditional formatting
Formatting based on other cells
Formula to determine formatting
Green fill
Highlight entire row
Highlight lowest value
Maximum value
New Conditional Formatting rule

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152818/

More from this channel