#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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. |
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 |
Remove white text background (keeping the font color and page color intact | cc3125 | Word | 1 | 10-26-2015 06:44 PM |