Create a formula based on date
Highlight your coulmn of dates
Format/ Conditional Formatting
Cell Value is/ less than or equals to/ =TODAY()/ set your appropriate red
format
Add
Cell Value is/ less than or equals to/ =TODAY()+30/ set your appropriate
yellow format.
--
David Biddulph
"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?
|