I have a list of employees and a start date wehn they joined the company.
what i am trying to do is enter a formula where if the date is 3 months later then the trianing date then that particaular cell is flagged and changes colour.
The hire date is formated as a medium date and i would like the relevant cells to be highlighted.

EmployeeName Hire Date TrainingDate Retrain
joe bloggs 29/07/2004 25/08/2004 No cell in red

i think i need to inlcude a if statment in the formula and try and add 3 to the months part of the date by just selecting the month from training date.

Does anyone know how to achieve this plz need some help

Thanks

Rich P