Excel: find the lowest/ highest values for rows or columns w/ conditional formatting by Chris Menard

You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting.
The MIN function finds the lowest value. The MAX function finds the highest value. Combine the MIN or MAX function with Conditional Formatting, and you can find the lowest or highest values by row or columns.

The trick to doing this is using relative reference and selecting the correct range. To know which row has the lowest value, you select B2:E5. The conditional formatting function is =B2=MIN(B$2:B$5).

Chris Menard's website

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[MrLinkolin]

This was great, exactly what I was looking for and worked like a charm. Thanks!

[edsonrmorais]

Thanks Chris, great explanation, very concise and straight to the point. Subscribed!!

[ohsolis]

Thank you so much! Very helpful and the explanation is so clear that it's very easy to understand!

[alainvanleeuwen]

Exactly what I was looking for. Good explanation. Thanks.

[seanwinder]

Thank you, super helpful and time saving for my task!!!

[jeskg]

Thanks Chris. I really needed this today

[abak]

Thank you, Chis. I was stuck on this problem, and you really helped. God bless.

[anitagill]

That was very helpful and easy to follow, thank you.

[noroy]

Thank you Sir, you saved me a lot of work. Greetings from Mexico.

[stardust]

Thank you very much!!! Much luck to you.

[briansleath]

Thanks for this Chris. What if there are more than 1 equal to the lowest number and I only want to highlight if there is just one lowest number?

[vigneshwarim]

Thank you sir & well explained and so useful for my task

[najamaabbas]

Thanks, it works great.
In addition, is it possible to populate column heading name of the lowest value in column F?

[tahirif]

Could you do a video on comparing data against a column and highlight the greater values.

[efmoura]

You're the best guy teaching excel on YT

[mustafaefecetin]

Hi,
How could I compare column values with reference column and highlight the least and the most differences?

[leasairanen]

Hello, how can I highlight both max and min values in the same row?

[AshfaqAhmed-onuh]

Please guide to use one by one min & small functions with conditional formatting on non-adjacent cells i.e. each data row and column carry one blank row and column between these.

[sagrindentertainment]

Is there a way I can use conditional formatting to automatically go from smallest to largest amount?

[kelkarrajesh]

Can you tell us how filter zero amount in this table, I want smallest amount next to zero.