Time stamp update notification

I have a spread sheet in which I monitor the costs of food (mostly canned, boxed and bottled goods)

I use this sheet for my budgeting.

What I want to know is; is it possible for excel to notify me when the contents of a cell hasn't been updated for more than 2 months?

This would be very helpful as prices of food do increase over time.

I prefer it to be for an individual cell, and not an entire row (as I monitor the 3 supermarkets nearest to my house)


Here is a sample screen shot. \1

Hi,

You could put the date that you update in once cell and check if today's date is 60 days or more since that date with a formula like this:

=IF(TODAY()-A1>60,"Outdated prices","Current prices")

abousetta

Originally Posted by abousetta

Hi,

You could put the date that you update in once cell and check if today's date is 60 days or more since that date with a formula like this:

=IF(TODAY()-A1>60,"Outdated prices","Current prices")

Sorry, that would work for the entire sheet, not what I am looking for.....
I update rows/cells weekly once I take a look back at my shopping receipts.


I think I need something more of a macro... So on start up i get notifications on which items i havent altered for the past 2 months.

Doesn't excel save singular cell data? Stuff like:
User Name that edited a cell
Date and time the cell was edited?

Not normally. Even so, this information can be saved in a hidden sheet which Excel checks against. We need a dummy copy of your workbook and specific details of what you want saved, what you want checked and when you want it checked (e.g. on open, on close, etc.).

abousetta

Well here is the file I am working with.Attachment 133977