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

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

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

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