Lowest/biggest number

[Ruah93]

Hi everyone,

I am trying to find the lowest and the biggest value here. How can I do that with cond. formating and where the lowest goes green and the biggest goes red?

Thanks

[#2]

@Ruah93 

=MIN(B$2:B$11)=B2

You can apply this rule for conditional formatting in order to format the MIN of each column.

=MAX(B$2:B$11)=B2

This is the rule for the MAX by column.

=$B$2:$E$11

This is the range the format applies to in the example.

[#3]

@OliverScheurich Thank you very much for your reply!

I forgot to mention my excel is from IOS system and I have tried what you said but it gives me these alternative colors which I do not want: