Excel cell flash when date is near [Closed]

Posts
1
Registration date
Sunday April 5, 2009
Status
Member
Last seen
April 6, 2009
- - Latest reply: mubashir aziz
Posts
191
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
See more 

1 reply

Best answer
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
209
3
Thank you
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 .............

Say "Thank you" 3

A few words of thanks would be greatly appreciated. Add comment

CCM 5673 users have said thank you to us this month