create a macro that turns cells red 10 days after initial data was added to the cell

[bananius]

Hi everyone,

I hope someone can help with this... I have a schedule where people enter data into a different columns called "motions" which are spread out through the chart. When data is put into the motion chart I have set it up so that the corresponding cell in the column to the right show the date that data was entered.

What I need to do now is set up a macro, which turns the cells in the "motions" column red 10 ****business days**** after the data was initially entered *AND* to delete the data and cells 11 ****business days**** after the initial entry date.

Any help would be very appreciated! Thank you!

Here is what I have so far:

Please Login or Register  to view this content.

[Pauleyb]

I'd recommend using conditional formatting and the =WORKDAY function for the color coding. Then your macro should be simplified to just deleting rows with dates >10 workdays (which should be the same as >14 calendar days, correct? Unless you want to include holidays, which is where the WORKDAY function can help).

[bananius]

Ahh, yes! Thanks Pauley, I completely forgot about the holidays. That's a great idea.

[bananius]

...How would I go about doing this though?

[Pauleyb]

...How would I go about doing this though?

Which part? Conditional formatting? Deleting rows? Using WORKDAYS in VBA? It seems like you know how to do some programming, so I don't want to answer things that are obvious to you.