My goal is to get the file where everytime you open it, it compares the current date to the date within that particular cell. For example if cell B2's due date is 05/13/08 and you open the file on 05/14/08, it would automatically turn cell B2 red. Is this even possible in Excel?
I really do appreciate any information anyone can offer.
Bookmarks