#1
|
|||
|
|||
Gantt chart and conditional formatting confusion
Hello all,
On the attached file, how can I use the status Rag in column E to also show up on the periods that are highlighted on the right-hand side? Currently, I get either all cells highlighted with the status colour or none. I cannot see which part of the conditional formula I need to update... The picture below is for convenience. |
#2
|
||||
|
||||
See attached.
|
#3
|
|||
|
|||
Amazing. thanking you
|
Tags |
conditional formatting, gantt, rag |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart Fill Patterns Conditional Formatting | aramaglia | Excel Programming | 1 | 05-15-2017 06:35 AM |
Gantt Chart Help | SteMob | Excel | 1 | 02-04-2017 06:41 AM |
Conditional Formatting of Pie Chart | Jiing Chiang | Excel Programming | 0 | 01-31-2017 04:38 PM |
Gantt Chart | hdlarrain | Excel | 1 | 12-13-2015 03:13 AM |
Gantt chart bar formatting summ vs recurr task | Intruder | Project | 1 | 02-02-2014 08:19 AM |