Format cell based on another cell
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.