Excel Find the Min and Max Value in a Column using Conditional Formatting

[@k2rp]

Thanks. Helped me fix my issue.

[@TEKNISHA]

Glad that this helped you

[@MGSV626]

Perfect! Thank you

[@TEKNISHA]

You're welcome!

[@NK-iy6if]

Thank you, God bless you!

[@robl417]

Very helpful thank you.

[@1977ajax]

Looked at many vids on how to do this, and this was the only one that actually worked. Thanks.

[@aaravjain-thewonderkidstor1181]

THANKS FOR SOLVING MY PROBLEM

[@avilaazkaghani9450]

Thanks a lot sir.

[@rajeshdhawan1]

Thanks

[@balajipv1589]

Sir, It would be great If you could Explain the Min and Max Value for the Full year. Meaning selecting Multiple columns.

[@kadariadi]

Thanks a lot...

[@misssomod194]

Thank You

[@krunalmotka84]

Is it possible to have such highest and lowest value aftre applying filter in column

[@tommyharris5817]

How can you use CF to identify the top/bottom three values in each column?

[@rajdhanraj2]

Same question

[@humanazmeen1557]

Sir kindly let me know how to get highest and lowest number in each rows and columns ??

[@honeykaibarta7492]

sir, I have a question
find the values greater than 10000 in each column? please make a video on this

[@himmesshh]

I dont hv classic option in my excel

[@ggmasih4486]

Hi Sir,
What if we have 1468 columns. And we want to find the minimum value in the sets of 3 columns?
Is there a way to apply one formular and do it together instead of doing one by one?

[@TEKNISHA]

It should be possible. But I will need to see sample data.

[@saadbutt9530]

Hi, how to use this formatting if your selection is row wise not column wise.

[@amalpious655]

Did you find that

[@amalpious655]

Can help me too

[@norsazli71]

What if we want to exclude cells having 0 values as min?

[@agnazareth02]

how to formulate if need to ignore the 0 value and blanks?

[@21NightCrew]

how do i do this but with rows

[@sanketbhoir33]

Sir, I’m trying from morning but it shows only JAN months highest score not in every month… pls help in solve this issue

[@cutoutanimations6074]

Not working for the entire sheet , SHAM !! as it works only for C column

[@harsinchh4342]

How to highlight the column C, range - on the based on max value of column A to min value of column B.
A B C
50 60 1000
30 20 2000
[90] 50 (3000)
30 40 (1000)
20 [10] (5000)
40 80 80000
30 20 10000

[@harsinchh4342]

Sir,
A B C
20 40 30
(10) 50 [60
20 30 20
50 10 10
60 10 80
30 (90) 50]
20 20 70
From column A min value 10 to column b max value 90, how can I add column c all cells from max value to min value at column A to column B.

[@piyushlali]

If a blank cell is there then what to do??

[@happykilife2679]

Yesterday I Did It by same formula...
But today's I'm not getting success

[@harsinchh4342]

30