Use conditional formatting with a formula of

=A1=TODAY()-30

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jenn" wrote in message
...
I have a worksheet that contains the following:
*Subcontractors
*Their Liability insurance
*The insurance dates
What I do weekly is, manually go through the entire worksheet highlighting
the insurance that is expiring (within 30 days) or is already expired. I
highlight the 30days to expire, yellow & the already expired, I highlight
red.
Would a formula work best to automate this?