Time stamp update notification

[anonymust]

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)

 

[jim may]

You could use Conditional Formatting. Say your cell A1 contains the date of the last update. Select it (cell A1), then go to cinditional formatting and enter 1):FormulaIs
and in the textbox enter: =A1+60<Today() - Choose your Color of Choice.
Paint (using A1 as your base) all other cells you wish to apply this to...

 

[anonymust]

You could use Conditional Formatting. Say your cell A1 contains the date of the last update. Select it (cell A1), then go to cinditional formatting and enter 1):FormulaIs
and in the textbox enter: =A1+60<Today() - Choose your Color of Choice.
Paint (using A1 as your base) all other cells you wish to apply this to...

Well I dont have any cells that actually hold a date., or else that would mean I need to update the entire spreadsheet.

Every now and then when I check back my receipts I enter the new updated price on one or more items.

This spread sheet contains 78 items, and prices of 4 supermarkets.

Heres is a sample screenshot: