On 8 dec, 14:33, Ixtreme wrote:
Miguel

You should use conditional formatting to do that.

Something like:
=A1NOW() --- Red
and
=AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) ------
Orange