Forum Discussion
Formatting a cell to recognize number ranges and set color
In Excel, I want to format a specific cell to recognize three ranges (green , yellow , red) when the number is calculated. If the number is under .02 then the cell turns yellow if that number f...
Select the cells or cells that you want to format this way.
Set the fill 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 'less than' from the second drop down.
Enter =0.02 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 'greater than', =0.04 and red.