|
|
#2
11-29-2015, 10:36 AM
|
|||
|
|||
Your code ran fine for me but it is changing the background color - not the text color. I'd change the order of the second and third case statements as 100% is greater than zero. The case statement stops at the first true, so it never reaches the 100.
A quick search also turned up: https://msdn.microsoft.com/en-us/lib.../ff862901.aspx The FontEx method allows you to use the PJ colors https://msdn.microsoft.com/en-us/lib.../ff862872.aspx 
|
| Tags |
| colors, fields, task |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Physical % Complete and Task Duration | ChuckM | Project | 3 | 02-09-2014 09:21 AM |
| Change Cell Color Based On % Complete | jrfoley3 | Project | 1 | 05-30-2013 05:24 AM |
 Task Indicator - All predecessors complete true/false, y/n
|
jdove78 | Project | 2 | 10-10-2012 05:53 PM |
|
excel cannot complete this task with available resources - vlookup
|
Taisho | Excel | 4 | 01-27-2012 03:09 AM |
| Stop the % Complete of subatasks from counting against the Main task | bzeyger | Project | 0 | 06-08-2010 06:19 AM |
Windows 7 64bit 
Office 2013
Threaded Mode