Making cells change color after a specified period of time.

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Hi,

Does anyone know how to color cells after 30 days.

Thanks for your help
 
Do you mean:
The date in the cell <NOW() - 30 ? In which case you could use conditional
formatting using that as a criteria.

Or do you mean, the cell has not been changed in the last 30 days.
One possibility is to capture changes to a worksheet by hooking the _Change
event.
Then on a hidden sheet, paste the current date/time in the cell of the same
row/column.

If neither, then you'll have to clarify.

Rob
 
Sorry. There will be a cells with a dates and from those
dates anyhting over 30 days will change color
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tabname function 1
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
GridLines Inadvertantly Goes Away with Macro 3
creating rows of colored cells from adjacent numbers 8
Error Installing "ADAPTEC EZCD 4.04" 1
How to blank the colored cells? 0
Change cell color based on date 8
Cell Color changes On Input even if new input matches default 1

Back
Top