If it's about cell A1:

Cond. formatting
"Value is"
less than
today()-31



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alexa M." wrote:

How do I conditional format a date?

The date should be thirty one days old when it formats.


--
Alexa