Hi Atomic,

Try using this formula:

=IF(TODAY()D4,"Expired","In Date")

and then apply conditional formatting to the cell containing the
formula to change the colour when it reads 'Expired'

HTH

Regards

Michael.