Is this possible to change text colour(say to blue) after 10hrs automatically.
so that next day when i open sheet & start working i can easily differentiate
yesterday's work.

Is there any other way to do this?

Well, you can use conditional formatting...

Format Conditional Formatting

Formula is... <NOW()-(10/24)

then click format button and do your formatting.

Of course, this means those cells will be blue perpetually...

So, you could put in a 2nd format that changed them back to whatever format
if <NOW()-(34/24)

"aditya" wrote:

Is this possible to change text colour(say to blue) after 10hrs automatically.
so that next day when i open sheet & start working i can easily differentiate
yesterday's work.

Is there any other way to do this?

See Chip Pearson's site for how to set up an on-time macro event.

http://www.cpearson.com/excel/OnTime.aspx

But why don't you just select today's work and change the font before you
save and close?

You do save now and again, I hope.


Gord Dibben MS Excel MVP

On Mon, 1 Jun 2009 05:20:01 -0700, aditya
wrote:

Is this possible to change text colour(say to blue) after 10hrs automatically.
so that next day when i open sheet & start working i can easily differentiate
yesterday's work.

Is there any other way to do this?

hi Timmons,
i an facing difficulties..will you please elaborate?

(1)as soon as i put =now()-(10/24) in formula bar...a number like 39966.55
aapears. when should i use formating?

(2)what i exactly want is that whatever text i enter today in any cell
should turn blue tomorrow.

thanks in advance

"Sean Timmons" wrote:

Well, you can use conditional formatting...

Format Conditional Formatting

Formula is... <NOW()-(10/24)

then click format button and do your formatting.

Of course, this means those cells will be blue perpetually...

So, you could put in a 2nd format that changed them back to whatever format
if <NOW()-(34/24)

"aditya" wrote:

Is this possible to change text colour(say to blue) after 10hrs automatically.
so that next day when i open sheet & start working i can easily differentiate
yesterday's work.

Is there any other way to do this?

i did this in conditional formating...but it didnot work.
please help again.

"Sean Timmons" wrote:

Well, you can use conditional formatting...

Format Conditional Formatting

Formula is... <NOW()-(10/24)

then click format button and do your formatting.

Of course, this means those cells will be blue perpetually...

So, you could put in a 2nd format that changed them back to whatever format
if <NOW()-(34/24)

"aditya" wrote:

Is this possible to change text colour(say to blue) after 10hrs automatically.
so that next day when i open sheet & start working i can easily differentiate
yesterday's work.

Is there any other way to do this?

39966.55 is 6/2/09 1:12 PM. You can just change the formattign to date/time
to see that part. So, I would assume you entered that formula at 11:12 PM on
6/2.

I did neglect to add the < for less than, so:

<=now()-(10/24)

If you were to have that formula in your cell at 9:00 AM on 6/23, it would
turn any cell with a value of 6/22 11:00 PM or earlier to blue (assuming your
format as such)

"aditya" wrote:

hi Timmons,
i an facing difficulties..will you please elaborate?

(1)as soon as i put =now()-(10/24) in formula bar...a number like 39966.55
aapears. when should i use formating?

(2)what i exactly want is that whatever text i enter today in any cell
should turn blue tomorrow.

thanks in advance

"Sean Timmons" wrote:

Well, you can use conditional formatting...

Format Conditional Formatting

Formula is... <NOW()-(10/24)

then click format button and do your formatting.

Of course, this means those cells will be blue perpetually...

So, you could put in a 2nd format that changed them back to whatever format
if <NOW()-(34/24)

"aditya" wrote:

Is this possible to change text colour(say to blue) after 10hrs automatically.
so that next day when i open sheet & start working i can easily differentiate
yesterday's work.

Is there any other way to do this?