I am trying to find out how to get an excel spread sheet to hightlight a date when that date gets near. There must be a way for the sheet to recongize the date on the computer and perhaps hightlight the cell.
I know I can put =DATE() in a cell at the top. But how do I then tell the column w/ all the dates, that "when it gets 3 days before that date above, change color, flash, something so I know.
I realize I can simply sort, but well, that's not good enough.
Any advice, cuz I KNOW it's out there, would be greatly appreciated. Thanks!
Suppose you have data in Cell A1 to onward now select whole area from A1 to onward. Now Put Conditional Formatting Format > Conditional Format > Condition 1 : Forumula Is =
Change to Pattern
Format > Conditional Format > Format > Pattern & Select Red .....
it will inform you 2 days earlier by highlighting cell and if the date is on Monday then it will be highlighted on Friday .............