Training Info conditional formatting when out of date, due to expire and indate

[sid6478]

I need a conditional format that makes training dates red amber or green depending on if training is due with in 90 days in date or out of date some training requires refresh after 1 year others 2 or 5 can anyone help?

Sid

[JeteMc]

Hello Sid6478 and Welcome to Excel Forum.
It would help us to help you if you could upload a sample spreadsheet that demonstrates your problem. We probably need examples of one, two and five year expirations along with due in 90, in date and out of date. Manually apply the fill and/or font coloring that you would like to see in each case. We can then attempt to write formulas for conditional formatting rules that will replicate what you have.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.