Conditional Formatting: Check if cell is min value compared to all cells above it

Question

In Excel, starting in C2 I have a column of numbers.

I would like a conditional formatting rule applied to every number in that column that checks to see if it is smaller than all the numbers above it. If it is, it should be green.

For example:

185.1
186.7
185.4
184.9
185.0
183.6

184.9 and 183.6 should both be green.

After selecting all the values in the column, I created the following conditional formatting rule:

Format values where this formula is true:   ="<MIN($C$2:C2)"

...and then the format is set to have green text. It Applies to =$C$2:$C$150

But it doesn't work :(

Any thoughts on how to make this work?

Answer 1

In C3, try =C3=MIN(C$2:C3) Applies to =$C$3:$C$150. (Though personally I'd accept C1 and C2 being green and for Applies to use =$C:$C, with =C1=MIN(C$1:C1).)