Hello all,
I have attached a small sample file for reference; in reality my files are much larger hence the need for help.
I need help with specialized conditional formatting. As you will notes, Col. B has "Order dates" and Col. C has "Production date"; some dates for Col. C are filled others are not.
How would I go about formatting in a way where, EMPTY Col C "production dates" cells are highlighted when Order date + 30 days (or whatever amount of days I choose) are compared with the CURRENT date. If Order date + 30 days is LESS than today's date, then the empty Col. C "production date" cell would be highlighted.
I would really appreciate some help on this as it would dramatically reduce my time on these reports. Once again much thank you in advance!
Regards.
Bookmarks