I have a very basic spreadsheet with names and dates of last training. The training is due every year so if they took it on 1/1/2013 it would be due again on 1/1/2014.
In A3 to A7, I have names. In B3 to B7 I have their last training date. I want the date cells to highlight yellow when they are within 60 days of expiring and then highlight red when they are more than 1 year old.
I have tried several different things and cannot make it work. I am very much a novice so as simple as possible would be great...
TIA
Stephen
Bookmarks