Colored the cell with the least number

Hi there ;

i have a column with numbers , i would like to colored cell which has the the least number , i think i will do it with conditional formating but i could not find the choose the least number formatting.Do you have any advice for this topic

Thanks in advance

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You will need to create a helper column that outputs something on the row containing the lowest number and then create your conditional formatting based off of this helper column.

    =IF([Column Name]@row = MIN([Column Name]:[Column Name]), "Lowest")