Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2013, 12:11 PM
ketanco ketanco is offline Bar colors Windows 7 64bit Bar colors Office 2007
Expert
Bar colors
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default Bar colors

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?
Reply With Quote
  #2  
Old 03-30-2013, 08:24 AM
JulieS JulieS is offline Bar colors Windows 7 64bit Bar colors Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bar colors Unable to change font colors from theme colors choy Word 3 08-01-2012 09:12 PM
Bar colors Counting Colors 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
Bar colors Font colors JerryB Excel 1 11-30-2008 10:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft