Macro that uses System Date in conjunction with Conditional Formatting

Hi All,

After some help

I have a bunch of dates from say B1-B6.

What Im after is a macro that checks the system date, and if the system date is 28 days after the dates in B1-B6 the cell will turn red.

Is this difficult?

Much Appreciated.

Rob

Rob

Probably easier to use conditional formatting.

Select B1, then format, conditional formatting, formula is: =NOW()-B1>28, nominate your format, OK.

If you really want to have a macro, then this can be done.


rylo

Thanks for your reply.

That was fine... And works perfectly... Now instead if I put that formula in C1, but reading the date from B1, it makes my C1 Cell go red instead. How can I make it say "Due" with conditional formatting?

Cheers,