I am using MS Project 2007. I want to highlight overdue tasks in red color. Is there any way to do so?
I found the best approach is to use small colored icons in a number column: blue/green/yellow/red.
How I set it up
On an existing number column (e.g. Number1, etc), right-click and choose "Customize Fields" then select the individual field by name. Then, at the bottom of the form, click "Graphical Indicators" and set up ranges for each color icon, then choose the color icon itself.
For example, I wrote a custom formula (see below) that sets the value of Number1 based on the current date and the Finish date of each task. Then, using that value, I set up the Graphical Indicators to show a blue dot for complete, yellow for in progress, green for future, and red for overdue. Unfortunately, it's a bit of setup, but once it is done, it updates automatically. No macro or coding needed.
Custom Formula Setup
Paste the following into the Custom Attributes / Formula for any Number field (make sure it's all on one line):
Under Tools | Customize | Customize Fields..., set the display to "Graphical Indicators." Set it to "Nonsummary rows" and add the following tests:
Here's what it looks like in practice. Color coding:
I can get you closer but not all the way there. I figured out how to color code completed tasks but not late tasks.
Now, all finished tasks are color coded. I'm still trying to figure out the correct options for late tasks. It must be in there somewhere.
You format the text - I have a different version from yours but all versions have a way to do it. IF you can't find it in the ribbon, go to help and ask the question.