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 Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories