Search : in
By :

Excel cell flash when date is near

Last answer on Apr 13, 2009 8:54:25 am BST efh7557, on Apr 6, 2009 8:36:24 pm BST 
 Report this message to moderators

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

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Excel cell flash when date is near » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Ask your question Reply

1

 mubashir aziz, on Apr 13, 2009 8:54:25 am BST
  • +1

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

   
Reply to mubashir aziz
Ask your question Reply
They need your help