change text colour

A

aditya

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.
 
A

AltaEgo

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change text colour 5
Missing task list row and columns Lines along with Ganttchart non working day color 0
Word 2016 opening sooo slow 0
Word OLE to check spelling in text box 1
conditional formating new 3
changing colour cell and text by clicking cell 2
Using colour conditional formatting to show whether due date has past 0
OLE Word spelling 0

Top