Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Thread Tools
Display Modes


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 12:16 AM.


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