Hi all

I have a training matrix with names down the left and certifications, qualifications and other details along the top.

I want to automatically highlight all expired dates in red, and any coming up within 90 days in yellow. If it contains a date which is valid or if the cell is not a date at all, to leave it unformatted.

Googled a few guides but they dont seem to work properly and my sheet also contains other than apart from dates.

Is there a way to do this?