Training Expiry Dates

Options

I have a sheet that stores all training records. Some expire in 3 years, some in 1 year....it varies.

Each type of training is housed in one column and employee names listed in the rows.

Is there any way to use conditional formatting on a column to highlight a specific cell when an original training completion date that goes over 3 years (or whatever the expiration range is)?

I couldn't figure out what to choose

Answers