Excel doesn't keep track of when you make changes.

You'll have to provide a way to do that. You could do the date/time entry
yourself. Or you could use an event macro that fires when you make a change to
the worksheet.

Take a look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

If you want to try.

aditya wrote:

Hi Dave,
I want to change the text colour automatically 10hrs after entering it.

"Dave Peterson" wrote:

You'd have to keep track of the date and time you entered the value. Then you
could use that cell to color the cell you want.

aditya wrote:

what should i use in conditional formating if i want to change text colour to
blue 10hrs after entering it.

--

Dave Peterson


--

Dave Peterson