Excel cell flash when date is near [Closed]

Report
Posts
1
Registration date
Sunday April 5, 2009
Status
Member
Last seen
April 6, 2009
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

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

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

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!