Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for date highlighting....
I am trying to create a macro that will go through col. B and highlight anything 14-29 days old in Yellow, and anything 29 days or older in red. Can Anyone suggest a macro for me? I have created a formula to do so but when I try to copy data from a PCOM session and paste the data into the spreedsheet the formula does not work. I have to manually reenter date for the highlighting to work. Any Help would be appreciated on this one. -- mauddib13 ------------------------------------------------------------------------ mauddib13's Profile: http://www.excelforum.com/member.php...o&userid=25785 View this thread: http://www.excelforum.com/showthread...hreadid=391908 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for date highlighting....
You don't need a macro, use conditional formatting.
Select the cells, and use a formula of =AND(B2<TODAY()-14,B2=TODAY()-29) and set a pattern colour -- HTH RP (remove nothere from the email address if mailing direct) "mauddib13" wrote in message ... I am trying to create a macro that will go through col. B and highlight anything 14-29 days old in Yellow, and anything 29 days or older in red. Can Anyone suggest a macro for me? I have created a formula to do so but when I try to copy data from a PCOM session and paste the data into the spreedsheet the formula does not work. I have to manually reenter date for the highlighting to work. Any Help would be appreciated on this one. -- mauddib13 ------------------------------------------------------------------------ mauddib13's Profile: http://www.excelforum.com/member.php...o&userid=25785 View this thread: http://www.excelforum.com/showthread...hreadid=391908 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for date highlighting....
I tried using that formula but it does not work correctly. Not sure if am doing it wrong but I copied it into the conditional formating optio and it does not work -- mauddib1 ----------------------------------------------------------------------- mauddib13's Profile: http://www.excelforum.com/member.php...fo&userid=2578 View this thread: http://www.excelforum.com/showthread.php?threadid=39190 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for date highlighting....
I can post a sample workbook to a file hosting site if you want.
-- HTH RP (remove nothere from the email address if mailing direct) "mauddib13" wrote in message ... I tried using that formula but it does not work correctly. Not sure if I am doing it wrong but I copied it into the conditional formating option and it does not work. -- mauddib13 ------------------------------------------------------------------------ mauddib13's Profile: http://www.excelforum.com/member.php...o&userid=25785 View this thread: http://www.excelforum.com/showthread...hreadid=391908 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for date highlighting....
Sure if you could I would appreciate it.. -- mauddib1 ----------------------------------------------------------------------- mauddib13's Profile: http://www.excelforum.com/member.php...fo&userid=2578 View this thread: http://www.excelforum.com/showthread.php?threadid=39190 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for date highlighting....
Okay, you can find it at http://cjoint.com/?iclk4zAlJP
-- HTH RP (remove nothere from the email address if mailing direct) "mauddib13" wrote in message ... Sure if you could I would appreciate it... -- mauddib13 ------------------------------------------------------------------------ mauddib13's Profile: http://www.excelforum.com/member.php...o&userid=25785 View this thread: http://www.excelforum.com/showthread...hreadid=391908 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto highlighting x#of days prior to & after any given date | Excel Worksheet Functions | |||
Excel 2000 - Highlighting a date. | Excel Discussion (Misc queries) | |||
Conditional formatting and Highlighting Date Range | Excel Discussion (Misc queries) | |||
Date highlighting | Excel Discussion (Misc queries) | |||
Highlighting date cells before the event elapses | Excel Discussion (Misc queries) |