change the color of the text in a cell one day after creation of it

[Arebrahimi]

I want to announce to whom shared the sheet with him that I type a new text in a cell and after 24 hour the color of characters change.in the other word he could recognize if the text typed in the passed 24 hours or is older. any other suggestion to announce him to newly written cell?

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

change the color of the text in a cell one day after creation of it

Cross-posted at https://www.mrexcel.com/board/threads/change-the-color-of-the-text-in-a-cell-one-day-after-creation-of-it.1250937/ I want to announce to whom shared the sheet with him that I type a new text in a cell and after 24 hour the color of characters change.in the other word he could...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[t0ny84]

Using time could be quite a challenge as you would need to include the time in your cell and then extract this and compare it to the current time. You would then need to use this formula as part of a conditional formatting rule.

Could you not speak with the other person and agree that when you have edited the text you would change it's formatting e.g. highlight the cell(s), bold text, etc.

 

[Arebrahimi]

Since the messages are really written during the purchase process, it is imperative that they be changed immediately.
carried out automatically.
It is also challenging for other viewers to discern which message is fresh. The staff members' next task is to confirm that they have viewed these communications. One way to do this is by clicking on the recently entered text and altering its format.