1. Should be easiest question ever:
Excel 2007
My task tracker has a column that requires completion 30 days out. Formula in colum H is =E2-30; E2 is today's date and -30 is 30 days out. Simple step I cannot figure out:
As the task becomes overdue, wondering how I turn the date red in color. It seem easy until I realized ALL of the dates were red whether overdue or current. If you can stop laughing, please assist.
Bookmarks