Colored the cell with the least number

Automatic Mail

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

Paul Newcome

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")

Paul Newcome

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")

Automatic Mail

thanks for your advice @Paul Newcome ;

just i would like to ask that , ok when i create a helper column like that i can manage this issue but , when user enter a new row somebody must copy this new cell formula , is there any way that when a user enter a new row this helping column will be automaticly copy itself for the datas which are will be entered in the future

Automatic Mail

Also @Paul Newcome ; when i use your formula all the cells writing " lowest" there should be a mistake about formula ?

Paul Newcome

How are your numbers being populated exactly?

Automatic Mail

@Paul Newcome You can see as above left column with numbers right column your formula that you advice me

Paul Newcome

Right. So it looks like your numbers are actually being stored as text on the back-end. How are those numbers being populated?

Automatic Mail

goodmorning @Paul Newcome i choosed as below for class , we enter directly as number to cell

Paul Newcome

Are you able to provide a screenshot of the formula directly in the sheet similar to the screenshot below?

Automatic Mail

Sure @Paul Newcome , here you can see as below screenshot of my formula

Paul Newcome

You need to remove the "@row" from after the column names inside of the MIN function.