conditional formating new

[aditya]

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

 

[Dave Peterson]

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]

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

 

[Dave Peterson]

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.