conditionnel formating - colors

[K3tt3ch0u]

Hi,

I'm looking for a way to make a formula which could put the color of the lowest data of the line.

Let me explain, i'm making a excel file to compare the price of my suppliers.

every supplier have a color code. when i'm writing a price, i need it to be compare to the others.

i would like my unit to be in the same color of the source unit.

at the moment, here is the formula :

=MIN(SI((($F31:$V31)>0)*(Ambiant!$F$2:$V$2="Prix Unitaires");$F31:$V31))

But for a reason i ignore, it doesn't work for the color....

Do you have any idea of what's wrong in my formula?

thanks by advance

French "notgeekatall"

[#2]

Hello, @K3tt3ch0u 

If you would like to use conditional formatting to color the lowest value of a range, select conditional formatting, choose "Format only cells that contain", then Cell Value equal to =Min(Range).

Hope this helps!