![]() |
|
#1
|
|||
|
|||
![]()
Hello,
Is it possible to show dates and bars in different colors based on the Status field of a task? based on the value of schedule field being on schedule, late or future, I like to obtain different colors for the bars and dates. Is this possible? If so How? |
#2
|
|||
|
|||
![]()
Using several Flag fields and some new bar styles, it is possible to change the bar color.
To the best of my knowledge, you cannot set Text styles in that manner. The values for the Status field are: Complete = 0 On Schedule = 1 Late = 2 Future Task = 3 You will need four flag fields - one for each of the status possibilities. For the custom formula try: IIf([Status] = 0, Yes, No) Change for each status in each one of the four flag fields. For details on creating bar styles based upon Flag fields see FAQ 31 at: http://project.mvps.org/faqs.htm |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
choy | Word | 3 | 08-01-2012 09:12 PM |
![]() |
g48dd | Excel | 2 | 03-13-2011 09:28 PM |
Hyperlink colors | pamm13 | Word | 2 | 02-18-2011 08:51 AM |
Different Colors for Each Section? | l1willia | Word | 0 | 12-30-2010 11:49 AM |
![]() |
JerryB | Excel | 1 | 11-30-2008 10:23 AM |