Training Matrix - Conditional Formatting for dates occuring

Hi there,

New to the forum and in need of help with conditional formatting.

I am creating a training matrix that keeps track of different certificates that workers have obtained. The dates in the matrix are the dates that the certificates were obtained, not the expiry dates. I'd like to set up conditional formatting that will show me what certificates are still valid (green), what certificates expire within 6 months (orange), and what certificates have already expired (red).

One of the problems I'm facing is that not all of the certificates expire at the same time; some last for 1 year, and some last for 3 years, and some last for 5 years, etc.

Therefore, I think I need to set up a conditional formatting formula for each column that will take into account the number of years that the certificate is valid for.

Any help with this would be greatly appreciated!

Thank you,
Sophie