Previous Topic Next Topic

Excel cell flash when date is near

Closed
efh7557 Posts 1 Registration date Sunday 5 April 2009 Status Member Last seen 6 April 2009 - 6 Apr 2009 à 15:36
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 13 Apr 2009 à 03:54
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
Related:

1 response

Réponse 1 / 1
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
13 Apr 2009 à 03:54
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 .............