I would like to keep a record of people who are First Aid trained at work.
I currently have a list of peoples names going downwards, B3 to B48 and the
next column C3 to C48 indicates a Yes or No answer to show either they're in
date or out of date and two totals at the bottom have a formula stating the
combined figures. =COUNTIF(C3:C48,"Y")
=COUNTIF(C3:C48,"N")
The next column D3 to D48 states the date they were trained.

As the training dates are always different and the timescale of their
training runs out after a year, I would like the program to change the colour
of the cell date to yellow when the run out date is within 2 months, then
changes to orange when the run out date is within one month and any out of
date training to be coloured red. Any indate trained personnel be coloured
white.
The column would be D3 to D48 and I know there's an answer to this, but
don't know what question or where to look for the answer.
Can you help?