All,
I am attempting to create a formula (to no avail) for Column E; for dates older than 90 days, and future. Let me explain. In the attached workbook you will notice I have several rules for Column E. The ones I am having trouble with are for "Company 3 & 4".
My goal would be to have a formula for dates in Column E greater than 90 days to be indicated with red fill (Company 3, cell E4); and to create a formula to indicate if a future date was entered with some other color (Company 4, cell E5).
Cells F1:G1 are for Today's Date.
Any help would be appreciated. I've searched the forums and found many other great ideas; just not one I can modify to fit my situation.
Thanks in advance.
Bookmarks