Create a formula based on date
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?
|