Forum Discussion

Ruah93's avatar
Ruah93
Copper Contributor
Dec 12, 2023

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

 

excel
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 12, 2023

    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.

    • Ruah93's avatar
      Ruah93
      Copper Contributor
      Dec 12, 2023

      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:

Resources