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

Conditional format

Copper Contributor


In my cell I want to show;

  • a red background if the cell value is above 10,
  • or a yellow background if the cell value is above 2 and below 10,
  • or a green background if the cell value is below 2 



Bjrn 680

1 Reply



Select the cell or cells that you want to format.

Set the background color to green. This will be the default.


On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Format only cells that contain'.

Leave the first drop down set to 'Cell Value'.

Select 'greater than or equal to' from the second drop down.

Enter 2 in the box next to it.

Click Format...

Activate the Fill tab.

Select yellow.

Click OK, then click OK again.


Repeat these steps, but with 10 instead of 2 and red instead of yellow.