While you can set Gantt Chart Bar Styles to automatically change colours based on defined conditions or criteria, you cannot do same with Text Styles (to best of my knowledge).

So, when a visitor to my YouTube channel requested a tutorial on how to auto-change text colour for tasks that are 100% complete, the best I could come up with, is to run a simple macro. And the video below contains the code and the steps to follow.

If prompted the next time you open the Project file, you can click the Enable Macros button.

One of the visitor’s to my YouTube requested the code for updating the colour of cells of specific columns of a View based on the percent complete status of a task (i.e. %, Start & Finish columns) .

The code below is a solution I have come up and I must confess, it is not the most efficient code but it is a quick solution that works.