Conditional Formatting Based on Frequency

Hi all, Just wondering if it's possible to highlight a row using conditional formatting based on one column displaying the frequency of a particular entry? Example screenshot below! ...

excel

HansVogelaar
Aug 31, 2021
LL1991

Select A2:C6 (or however far down the data go).

The active cell in the selection should be in row 2.

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

Select 'Use a formula to determine which cells to format'.

Enter the formula =AND($B2<>"",$C2<>"")

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

Repeat the above steps, but with the formula

=$C2>=TODAY()-IF($B2="Monthly",40,IF($B2="Quarterly",100,365))

and orange.

Finally, repeat them again with the formula

=$C2>=TODAY()-IF($B2="Monthly",30,IF($B2="Quarterly",90,365))

and green.