Hi All-
I'm working on a spreadsheet in Excel 2007, and im having an issue.
Ok here goes, i have a =now() in cell F1, and an anticipated date of completion in column G, i need column G to hightlight in red the day before it is due. For example today (F1) is 11/21/11, i need everything in column G that is 11/20/11 to highlight in red and so on when the date changes daily.
Hope i made sense and you can help!
Thanks Canada
Bookmarks