Forum Discussion
scampbell11
Aug 28, 2024Copper Contributor
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!
See the attached version.
- scampbell11Copper ContributorWow - thank you very much! This is exactly what I needed!