If Cell Value is Greater Than Another Cell Value by 2 Years, Highlight Red

Hello,

I hope I've posted in the right place. I have tried searching on this forum, Google & Youtube and I can't find an answer to my query.

I have a spreadsheet that records "Audit Date" in column C & "Audit Due Date" in column D. "Audit Due Date" is always 2 years from "Audit Date". I think I learnt the correct forumla to use =EDATE(C2,24). What I would like Excel to do is to highlight "Audit Due Date":

Red: If the audit was completed 1.5 years+
Amber: If the audit was completed between 1 & 1.5 years
Green: If the audit was completed less than 1 year

The colour key will show me which audits need chasing.

I've attached a sample of my spreadsheet and would really appreciate if anyone could help.

Thank you.

Jessica

Hello,

Sorry, should have included that, I have Excel 2010.

Jessica