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 :
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
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!