Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? please elaborate the process. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
The easiest way would be to select all completed cells and format the text
blue when you first open your spreadsheet. To automate the process would require the incorporation of a date/time cell, conditional formatting, VBA or combination (depending on existing data). -- Steve "aditya" wrote in message ... 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? please elaborate the process. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change text colour | Excel Discussion (Misc queries) | |||
Change Text Colour | Excel Discussion (Misc queries) | |||
Change text colour | Charts and Charting in Excel | |||
change text colour | New Users to Excel | |||
Change Colour OF Text??? | Excel Discussion (Misc queries) |