OK, hoping some out there can solve this one for me!
I have got a excel file i use to keep track of my companies training records and currently I have set the conditional formating to have dates in GREEN when the employees training is valid and RED when it has expired.
What I would like it to do is go AMBER (or somethhing similar) when it is 3 months from the date in the cell.
Im sure this is dead easy to do, but i just cant figure the damn thing out!
Hope someone out there can help on this.
I thank you in advance
Steve Man
Bookmarks