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.

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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.

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Sure if you could I would appreciate it...

Okay, you can find it at http://cjoint.com/?iclk4zAlJP

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mauddib13" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>