Training Expiry Dates
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