Date calculations

[Mothra]

I'm getting a bit stuck with date calculations. I'm trying to make a cell
that changes colour when it expires, but I can't seem to get the right
syntax for the cell formula. This is kind of what I'm trying to acheive,
but I'm rather new to Excel formulae and the help file doesn't have very
many useful examples.

=if((DATE_VALUE(NOW)) > (DATE_VALUE("12/12/2002"), "expired", "time left")

BTW, I'm not sure how to change the cell colour either.

 

[Mike]

=IF(NOW()>DATE(2002,12,12), "expired", "time left")