Hi this is my first post and hopefully someone can help.

I have a spreadsheet to manage tasks for a large team. I have Frequency in column D and Date in column F. The frequency is a data validation drop down list that ranges from Daily, weekly, fortnightly, monthly, random, N/A. The team enters the date they last reviewed a task in column F, that review is indicted when it needs to be done in the Frequency column D.

So what I’m wanting to do is if columns in D state “monthly” then for the dates in column F to be highlighted if they are older than 1 month. If D states weekly then F highlighted if older than 7 days. So on and so forth for the following.

• Daily = 1 day
• Weekly = 7 days
• Fortnightly = 14 days
• Monthly = 30 days
• Random = 90 days

However, the frequency could possibly change from say weekly to monthly. So I want to be able to select the new frequency and it automatically pick up the new date range.

Is this possible??

Thanks
Meagan