Frequent used: =$C6="Monthly"
excel.png
possible to do as below?
When monthly selected, conditional formatting (fill) as below
m.png
When weekly selected, conditional formatting (fill) as below
w.png
When halfyearly selected, conditional formatting (fill) as below
h.png
When quarterly selected, conditional formatting (fill) as below
Bookmarks