Forum Discussion
Lowest/biggest number
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
=MIN(B$2:B$11)=B2You can apply this rule for conditional formatting in order to format the MIN of each column.
=MAX(B$2:B$11)=B2This is the rule for the MAX by column.
=$B$2:$E$11This is the range the format applies to in the example.
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: