Excel cell flash when date is near

Closed
efh7557 Posts 1 Registration date Sunday April 5, 2009 Status Member Last seen April 6, 2009 - Apr 6, 2009 at 03:36 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 13, 2009 at 03:54 AM
Hi,

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!


Erin
Denver

1 reply

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 160
Apr 13, 2009 at 03:54 AM
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 =
=IF(TEXT(A1,"DDD")="Mon",A1-3<=TODAY(),A1-2<=TODAY())

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 .............
4