Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Lowest/biggest number

Copper Contributor

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

 

Captura de ecrã 2023-12-12, às 12.11.44.png

2 Replies

@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.

conditional formatting.png

@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:

Captura de ecrã 2023-12-12, às 15.09.53.png