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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change text colour 5
Changing row background from external program 0
Conditional Formatting - Excel 2003 2
Excel does not accept text format! 0
Conditional Formatting question.... 1
Is it possible to edit colours already saved as part of a custom theme? 0
Table of content - format does not get saved 2
How can i put text in a cell depending on colour 0

Top