One further step in gantt chart conditional formatting
Posted on 2013-01-30
Am hoping this is a relatively easy query!
Have constructed gantt chart which autocolours using conditional formatting based on start and end dates for each task: =IF(AND(G$4>=$D6, G$4<=$E6),1,"") where G4 is the calendar date, D6 is the task start date and E6 is the task end date.
I would like to know if it is possible to in addition to have the conditional formatting colours on a RAG basis dependant on an additional status column ie green/completed, amber/ongoing and red/not started while still maintaining the original "base" colour to show the full timescale allocated to the task? So in effect up until the current date would show as RAG and remainder until end of task would show as base colour.
If this is not possible any ideas on good ways to show the progress on the gantt in alternative ways?