Change date display after specified time

[gcol]

I have a few columns of dates and I'd like them to be displayed in a different colour (or have the cell change colour) when 6 months has passed. For example if the date in the cell is 12/09/06 and the current date is 13/03/07 then it'd be over 6 months so I'd like the date 12/09/06 to change to a red text colour or have the cell change colour. Or even better, to have it flash.

[daddylonglegs]

You can make the cell red (but not flash) using conditional formatting. If your date is in A1, for example then select A1 and use

Format > Conditional Formatting > "formula is" option with formula

=(A1<>"")*(DATEDIF(A1+1,TODAY(),"m")>5)

select required formatting

[sweep]

or conditional format if cell is greater than =TODAY()-182

[gcol]

Guys that's brilliant. Thanks very much!!!!

[gcol]

Further to this, is it possible to have Excel send me an e-mail when these dates pass the 6 month point so I don't have to keep monitoring the spreadsheet?