Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

scampbell11's avatar
scampbell11
Copper Contributor
Aug 28, 2024

Conditional formatting for Gantt chart bar based on another cell

I looked through the help topics and tried copying several other formulas, but can't get this to work.

 

I'm creating a Gantt chart and would like to add a conditional formatting rule where the Gantt chart bar (which is currently blue) turns red if the "Lead" for that row is "Milestone". 

 

https://docs.google.com/spreadsheets/d/1P_16ZsdwawvFmGkBFXBcsklo69MzA2zb/edit?usp=sharing&ouid=109402566229526341381&rtpof=true&sd=true 

Any help is appreciated!

Resources