Forum Discussion
Conditional Formatting - Multiple Months
What about 6 to 9 months? You can create an extra rule for that if necessary.
Select J2:J6, J2 should be the active cell in the selection.
Set the fill color to red. 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 dropdown set to 'Cell Value'.
Select 'greater than or equal to' from the second dropdown.
Enter the formula =3*I2 in the box next to it.
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then OK.
Repeat these steps but with the formula =9*I2 and green as fill color.
What about 6 to 9 months? You can create an extra rule for that if necessary.
Select J2:J6, J2 should be the active cell in the selection.
Set the fill color to red. 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 dropdown set to 'Cell Value'.
Select 'greater than or equal to' from the second dropdown.
Enter the formula =3*I2 in the box next to it.
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then OK.
Repeat these steps but with the formula =9*I2 and green as fill color.
- Hans Vogelaar that works, thank you.
