conditional formating new

  • Thread starter Thread starter aditya
  • Start date Start date
A

aditya

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.
 
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
Conditional Formatting - Excel 2003 2
Excel Conditional Formatting Removal 7
Conditional formatting in Excel 2010 2
condition format 2
Excel Conditional Formatting 1
Conditional formatting 3
Font changed by Conditional Formatting 1

Back
Top