I am usin a spread shet in which I have target dates, I beli

Use Conditional Formatting.

Select the cells, or whole column etc where your dates are.
Go to Formatting-Conditional
[Condition1]
cell value ,greater than equal to,=today()
Click Format button
(set pattern colour to red)

hope this helps!!!!!