Flashing dates

Closed
dbailey - Apr 16, 2010 at 11:18 AM
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
- Apr 16, 2010 at 11:23 AM
If I have a colum in say colum g of a work sheet and I want to know when the date that is listed there is with in 30 days from now and the dates that are listed there I want them to flash the background color when they reach that 30 day window. how will I be able to do that? can you please show me what the code would be and the steps to make that happen please. I need this very soon to if that is possible.

you can also email it to me at dbailey@bbandt.com

Thanks in advace.


let me provide a little more detail and maybe that will help

work book is named (what is being done)

workk sheet is (What I am responible for )

I need colum P row 2-59 to flash if the date is with in 30 days of what ever todays date is.

I need either the date to flash or the background to change color to say like red letting me know that I need to perform the next step in my process. and that would be filling in the info into colum N same row as the line that is flashing or colored back ground.

can you please right the code for me for this exact example that i have mentioned so that I may put it into place. and with the instructions on how to, and where to put this info in.


2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 16, 2010 at 11:22 AM
0
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Apr 16, 2010 at 11:23 AM
have a look here

http://excel.tips.net/Pages/T002134_Flashing_Cells.html

And Here

http://ccm.net/forum/affich-66700-excel-make-cell-flash-red

And Here

http://www.pcmag.com/article2/0,2817,2023987,00.asp

Should keep you occupied for a while :-)
0