Use two worksheets.

In the first worksheet include a change event macro that records today's
date in sheet2. For example, if Z100 is changed in sheet1, the macro will
record today's date in sheet2!Z100 and format the text in sheet1!Z100 to red.

The next macro (in a standard module) will scan thru every cell on sheet2
looking for a date. If a date is found, and the date is more than two day's
stale, then the text color of the equivalent cell in sheet1 is changed back
to black. the second macro should be run once a day.
--
Gary's Student


" wrote:

Hi,

I have a spreadsheet with a large amount of text values held on it.

In order to improve usability I have been asked to implement a
formatting system whereby any cell which has been modified in the last
2 days is highlighted (e.g. red text).

After the 2 day period, the text is to revert back to blank text
formatting.

Any help, advice or alternative solutions would be much appreciated.

Many thanks.

Richard