Forum Discussion

K3tt3ch0u's avatar
K3tt3ch0u
Copper Contributor
Jun 18, 2019

conditionnel formating - colors

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"

Excel on Mac

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jun 19, 2019

    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!