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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920