Forum Discussion
Conditional formatting of Gantt chart
Hi! I am currently working on a Gantt chart for a project and have cells being colored blue if they are within the dates of a specific task.
Now I want to be able to fill out another cell with "yes" if the task is in the critical path of the project and then the blue cells should be colored red instead. Does someone know how to do this?
Thanks in advance!
I have added a new rule - you can view it in Conditional Formatting > Manage Rules...
4 Replies
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar thanks for your response. For some reason I don't have permission to attach files but here is a link to a similar workbook: https://liuonline-my.sharepoint.com/:x:/g/personal/davca341_student_liu_se/EeKP2PfVs39OisajHpLwHp4Bou2eK1s_pEVMAwuoEOhWJw?e=BBDXPL
Thanks!
I have added a new rule - you can view it in Conditional Formatting > Manage Rules...
