SOLVED

Conditional Formatting - Multiple Months

Copper Contributor

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.

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@AmandaLittle 

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.
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@AmandaLittle 

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.

View solution in original post