Use conditional formatting. If a date is in A1, then pick

condition1 formula is =A1-TODAY()<0
condition2 formula is =A1-TODAY()<30
--
Gary's Student


"Jenn" wrote:

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?