Formatting based on values in 2 columns (Text and Date)

Hi,

I am very new to PowerBi and would like to ask for some advice.

I have a SQL DB with a table (CAMR) which records when tasks were last performed.

Tasks are identified by Frequency, which is a text field, and Last Done Date, which is a datetime field.

I am trying to create a report which lists when the tasks were last done, DONE.

However, I would like to format it so that if a Weekly task`s hasn`t been done in the last 7 days, it changes background to red or something. And like wise, if a Monthly task hasn`t been done for 31 days, change background.

I have been able to get the datediff value in days, but not sure how to link this all up.

Any advice would be greatly appreciated.