Find the lowest / highest values for rows or columns with conditional formatting in Excel

Posted on:  08/04/2019
Find the lowest / highest values for rows or columns with conditional formatting in Excel

You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting. You will need to use eihter the MIN Function, which finds the lowest value, or the MAX function, which finds the highest value.

To find the lowest value by Rows

  1. Select your range
  2. Make sure you are on the Home Tab.
  3. Click Conditoinal Formatting, then New Rule.
  4. Click Use a formula to determine which cells to format.
  5. Type =B2=MIN($B2:$E2) then click Format - Fill tab - pick a color.
  6. Click OK.

To find the lowest value by Columns

  1. Select your range
  2. Make sure you are on the Home Tab.
  3. Click Conditoinal Formatting, then New Rule.
  4. Click Use a formula to determine which cells to format.
  5. Type =B2=MIN(B$2:B$5) then click Format - Fill tab - pick a color.
  6. Click OK.

YouTube Video by Chris Menard

Other videos on Conditional Formatting

Conditional Formatting with Dates

Anything over 30 days you want in a yellow background and anything over 60 in a green background. You will use the TODAY function in Excel with Conditional Formatting.

Conditional Formatting with the AND Function

To use Conditional Formatting based on two conditions in Excel, use the AND function.
=AND($E2="CA",$F2="Google Ads") to find people in CA that found you through Google Ads. 

Chris Menard's Excel Playlist on YouTube

Here are over 175 Excel training videos. Feel free to subscribe to my YouTube channel.

 

 

 

 

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories