How do I have fields change color based on the date of another field?
My Example:
Site Visited - 7/5/16
IRP Comments Due(15 days) - Projected date to submit comments by 7/20/16
Corps Comments Due (30 days) - Projected date to submit comments by 8/4/16
Based on the Site Visited - 7/5/16, I would like to have the IRP comments cell highlighted green until it reaches 10 days, after 10 days the cell would then highlight to yellow and after 15 days the cell would highlight red. For Corps comments the cell would be highlighted in green until it reaches 25 days past the original site visit, then it would turn yellow. After 30 days it would turn red.
Bookmarks