change text colour
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?
|