highlighting over due dates

[Nurofen]

Hi all,

I'm trying to highlight over due dates but having problems finding the right code to do the job.

In Col E the date is entered manually, depending on the Col B & C from a table Col D is populated with the frequency this will indicate the amount time aloud to passed before my next visit, If the date becames over due I would like it to be highlighted by key colors, also with an option to pass over non-working days Saturday and Sunday if needed between the start date and the visit date.

Thanking you for any help in advance

Regards

Nurofen

[Nurofen]

I have managed to get the conditional formatting to work. can this be converted into VBA so that I can pick the frequency for the due rather than having to change it manually for in each cell.

in cell F9 I entered =Date(year(E9),month(E9)+6,Day(E9))

in conditional formating a used
1 Cell value is less than or equal to Now()
2 Cell value is greater than or equal to Now()+20
3 Cell Value is less than or equal to Now()+19

When the color changes for the date in cell E9 how do I get cell F9 change to the same color.

Thank you for any help in advance
file attached with what I have done so far

Nurofen