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 certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff 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