Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2023, 07:49 AM
jtrout13 jtrout13 is offline Project Schedul Progretion Bar Color Windows 11 Project Schedul Progretion Bar Color Office 2021
Novice
Project Schedul Progretion Bar Color
 
Join Date: May 2023
Posts: 1
jtrout13 is on a distinguished road
Default Project Schedul Progretion Bar Color


I have a project schedule template made using Conditional formatting rules.

What i would like to do is change the color of the bar based on the text under the Assigned to column

I got it from this Microsoft link. Simple Gantt Chart | Microsoft Create
Reply With Quote
  #2  
Old 05-25-2023, 08:41 AM
p45cal's Avatar
p45cal p45cal is offline Project Schedul Progretion Bar Color Windows 10 Project Schedul Progretion Bar Color Office 2019
Expert
 
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

You're going to have to adjust the conditional formatting.
It's the conditional formatting (CF) which currently gives a purple colour and applies to the whole range I7:BL33.
1. You'll need to reduce the applies to range to the first section of rows and adjust its colour fill, then
2. duplicate this CF, then adjust the range it applies to, and its fill colour.
3. for each different colour you want.

Not something I'd look forward to doing but it's not that hard.
Reply With Quote
Reply

Tags
cell format, coditional formatting, gantt schedule work



Similar Threads
Thread Thread Starter Forum Replies Last Post
Feedback for Word Highlight Color Redaction Project PingLu Word VBA 0 02-15-2023 05:01 AM
Macro to change an RGB table cell shading color to another RGB color David Matthews Word VBA 4 05-29-2018 02:45 PM
Advanced Font Color Manipulation In Word: Inserting another color than the surrounding text stuartg Word 1 02-20-2017 12:38 AM
Microsoft Project Server, Microsoft Project Online and Project Web App - Whats the difference? chocolateCupcakes Project 1 02-11-2017 12:25 PM
Project Schedul Progretion Bar Color Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 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