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 supplie...
Excel on Mac
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!