I am creating a personnel certificate matrix where i am entering individual dates when a certificate was attained for each person.
I have spent 2 days trying to find a way to do this but after trying so many different ways i haven't found a solution yet.
So what i am trying to achieve is that depending on the duration that the certificate lasts for example - 2 years or 3 years or 5 years i am trying to use conditional formatting to highlight the cell containing the date one month before it expires?
If i cant use the same cell then maybe i could use a pivot table on a separate sheet and enter the interval for each certificate?
I will be using this formula for each certificate column
If anyone can help it would extremely helpful
Bookmarks