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!
Excel cell flash when date is near
Excel blinking cell without vba - Best answers
How to make a cell flash in excel without vba - Best answers
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 .............