Forum Discussion
Conditional Formatting - Multiple Months
Hello,
I need to conditionally format a column in this file that will turn the cells in column J red for less than 3 month, yellow for 3-6 months, and green for 9+ months based off the monthly usage in column I. (i.e. column I has monthly usage of 300 but column J OQS shows 10, the cell would turn red).
Any help or feedback is appreciated.
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.
2 Replies
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.
