C
Craig
I have a training matrix which shows the dates when each staff member had
training on a particular piece of equipment. Some of these have expiry dates.
For example three years after the date the certificate was issued for
chainsaw training.
What i would like to do is use some form of conditional formatting so that i
can type the number of years in one column and it would work out three years
from the date the certificate was issued and then turn red when the
certificate expired
For example in column A i would have the date the certificate was issued. In
column B i would have the number of years the certificate ran for. I need a
formula so that the box in column A turns red automatically when its reached
its expiry date.
All help appreciated
training on a particular piece of equipment. Some of these have expiry dates.
For example three years after the date the certificate was issued for
chainsaw training.
What i would like to do is use some form of conditional formatting so that i
can type the number of years in one column and it would work out three years
from the date the certificate was issued and then turn red when the
certificate expired
For example in column A i would have the date the certificate was issued. In
column B i would have the number of years the certificate ran for. I need a
formula so that the box in column A turns red automatically when its reached
its expiry date.
All help appreciated