Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting cell base

Forum home » Delegate support and help forum » Microsoft Project Training and help » Conditional formatting on cell based on start date

Conditional formatting on cell based on start date

ResolvedVersion 2010
Edited on Tue 21 Aug 2012, 10:43

Matthew has attended:
Project Introduction course
Project Intermediate course

Conditional formatting on cell based on start date

Hi There,

i am wondering if it is possible to use conditonal formatting or something similar in Project 2010, that will amend a task name a different colour if the start day of the task is less than 5 days away from current calender date?

This would be really helpful in this huge project plan i have?

Regards
Matt

RE: conditional formatting on cell based on start date

Thank you for your question.

Thank you for your question.
As far as I am aware, the Task Name cannot be used to change colour automatically based on a condition. This would require some VBA programming.

However you can use Graphical Indicators. This would put an icon in a new column against each task that shows whether the start day of the task is less than 5 days from the Current Date.
Here is how you would do it.

1. Go to the Project Tab
2. Choose Custom Fields
3. Choose Text Data Type from the top right.
4. Select Text 1 and click Rename and give it a relevant name.
5. Choose formula and copy the line below into the box:
IIf([Start]<date()-5,"1","2")

This formula says if the Task Start date is less than the current date - 5days, assign 1 otherwise assign 2. Click OK when it prompts about ‘existing data in field will be deleted…’

6. Click on Graphical Indicators and choose Equals in the first Test box, then type 1 in the value box and then an icon that will represent any task start dates that are less than 5 days from the current date.

7. On the next row repeat the equal, type 2 as the value and then a different icon.

8. Finally, insert the column which represents the custom field you created.

I hope this answers your question.

Regards

Simon

Tue 28 Aug 2012: Automatically marked as resolved.

MS Project tip:

Using the Quick Access Toolbar in Project 2010

The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.