Conditional formatting a cell(s) with a date formula within cell; multiple IF statements

Attached is the spreadsheet working on and am stuck in two areas.
1) The cell range of D3:I42 - I tried creating a conditional format so if the value is equal to the current year, it should stand out (red color for example). There is a conditional format in there but it fails to do what I thought it would.
2) Column J - I put the formula in J3 and J4 but this does not work. What it should do is if any of the cells have the value of the current year, then a comment should be placed in there. (See farther down Column J for sample comments I just wrote in there). I would like each service year (7,10,15, etc.) to have its own color so it would be easier to note which employees are up for which award.

Am somewhat a novice but it seems Excel does not recognize the value of the cell as '2012' (the current year) otherwise whatever is set up to happen, should trigger. Help please.

TheMick
Annual Service Awards-2.xls

Hi themick

Try: YEAR(D3)=YEAR(TODAY())

If I place this as the formula for the conditional rule, it doesn't change anything for the range. Is this where you meant I should put that?

Hi themick

See the attached!

Thank you so much, I had " " around the formula and that was keeping it from working properly (am guessing a copy/paste issue).
One more question if you would be so kind - Column J4 has this formula in it:

=IF(D4=YEAR(TODAY()),"7 YEARS",IF(E4=YEAR(TODAY()),"10 YEARS",IF(F4=YEAR(TODAY()),"15 YEARS",IF(G4=YEAR(TODAY()),"20 YEARS",IF(H4=YEAR(TODAY()),"25 YEARS",IF(I4=YEAR(TODAY()),"30 YEARS",""))))))

It should trigger because F4 is 2012 - where am i missing on this formula?

Hi themick

I have replaced that formula with another one, check your workbook I uploaded in post #4.

Wow-I would not have come up with that on my own. I greatly appreciate your assistance helping me get this created. Happy Thanksgiving

Mike

Thank you again for your input, that does clarify for me.