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?




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

2 Replies



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


This is the rule for the MAX by column.


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