ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   change text colour (https://www.excelbanter.com/new-users-excel/232701-change-text-colour.html)

Aditya

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


AltaEgo

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



All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com