conditional formating new

A

aditya

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

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.
 
A

aditya

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

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.
 
Top