I have a spreadsheet which keeps up with employees training. Column "I" contains the date training was taken. Column "J" contains the date training expires by using a formula which calculates one year from the date in column "I". When the date in Column "J" is reached, I would like for the corresponding cell in Column "K" to turn red and EXPIRED appear in white.
Can this be done with VBA or do I need a formula or condtional formatting? I've tried a lot of things but nothing seem to work.

You can do that with the combination of an IF Function and Conditional Formatting

=IF(J1<TODAY(),"Expired","") in Column K

should check for the date and update Column as expired

Then you can have Conditional formatting to check for 'Expired' and do the rest

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips &amp; Tricks (http://www.vbadud.blogspot.com)