Flashing Date in excel

[Ienni1983]

Hello All,

this is my very first post and also first question since I am breaking my brains over this one since I have been working with Excel 2007.

I have solved many problems with the solutions presented here.

I have multiple workbooks which contains numerous different dates.

and I need to make them flash when the dates are due within one week etc.

I would like to know what kind of command in vba or formula in excel it needs.

Kind Regards,
Vincent Arjan van Vessem

 

[Ienni1983]

I think what I want is not able to be done.

what I want is the next example:

today is 15/6/2009
There is a checkup due in 8 days.
but what I want is when that checkup has exactly 7 days and counting.
so once it the date is 16/6/2009 the date has to start flash red.

but what I noticed is that you can only enter an specific date and not like

"NextTime = Now + DateValue(7)

where the 7 is the datetext version of 7 days from now on.

(start to flash when highlighted date is within the range of one week.

 

[picklefactory]

Can you add an additional column or row to your sheet? Only thing I can think of is to try and run the function using a trigger from another cell. Your extra column or row could have a simple IF formula based on start date and target date, that when true runs the function. I'm sorry I'm not good enough with VBA to solve completely, but I think that would work. I know that you can somehow save that procedure as a user function, and I think that could be called from a formula.
I'm sure someone here will correct me if I'm talking rubbish.