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?