Hi all,
I am having a small excel problem, and I was hoping that the wonderful Excel Forum community could help me out?
I maintain an employee training database, and Column D contains "Date Trained".
All I need to do is set a conditional formatting on Column D that highlights the date trained (Red) once a year has passed.
The only caveat that is making this difficult is that the dates are mixed on the spreadsheet, which may/may not make this more difficult to accomplish.
Ex.
Contreras 4/12/2012
Duran 4/12/2010
Gamble 8/10/2012
Gyimah 12/12/2011
Hale 8/10/2012
Jaimes 4/12/2011
etc.
I get the feeling that it's a simple solution, but I haven't been able to figure it out all day!
Any help is greatly appreciated. Thanks so much in advance
-Chris
Bookmarks