Hello All,
I have a sheet with a list of names in column A and the dates that they attended training in column B (and subsequent for different training types).
As, each person has to redo their training after two years, I was hoping that I could get the cells in column B to go red once two years has passed based on the various dates in column B.
<tbody>
</tbody>
Any suggestions? I really don't know how to proceed.
VBA or some quirk of general Conditional Formatting is fine with me!
Many thanks in advance,
Dave
I have a sheet with a list of names in column A and the dates that they attended training in column B (and subsequent for different training types).
As, each person has to redo their training after two years, I was hoping that I could get the cells in column B to go red once two years has passed based on the various dates in column B.
Name | Training |
John | 12/02/2015 |
Dave | 05/12/2013 |
Mike | 08/06/2012 |
Bill | 09/03/2016 |
<tbody>
</tbody>
Any suggestions? I really don't know how to proceed.
VBA or some quirk of general Conditional Formatting is fine with me!
Many thanks in advance,
Dave