Automatically Delete Cell contents after 100 days

[JediDA]

Hi there,

I create a magazine every month that uses an excel sheet to pull data from. Whenever there are new products introduced, we like to call them out, and I've set up the magazine to automatically highlight the individual item on the page if the word "New" is in Column I (Highlight) and call out the page if the word "New" is in Column H (Header Shield). Generally, when we call a product new, we continue calling it new for 3 issues, after that, it's hard to justify still calling it new. Here's the problem. Given the rest of what's involved in producing this magazine myself, and the sheer number of products in it, it's difficult to remember how long ago a specific item was introduced and when it's time to remove the callout. To that end, I was wondering if there's a way to start a clock on any cell in those two columns whenever the word "New" is put in (and only the word New, because there are other callouts that don't need to be timed, like "Top Seller" or "2x deals" etc…) and automatically clear the cell one the timer hits 100 days. Is this even possible, or is it a pipe dream

Here is a small sample of the excel sheet I'm working with.
Full Month item listing Sample.xlsm

As a side note, I currently have code in the sheet that adjusts the font size of headers that I wouldn't want to stop using or mess up:

Please Login or Register  to view this content.

Thanks for all your help.

[Mumps1]

I had a look at you file and it does strange things when I enter "New" in columns H and I. Having said that, one approach you could try is to add the following code to your Worksheet_Change event:

Please Login or Register  to view this content.

This code will place today's date in the corresponding row in column AC when "New" is entered in column "H". Then you could use a Workbook_Open() event or Worksheet_Activate() event to check the dates in column AC and if they are more than 100 days old, the code can clear the appropriate cells.