Checkbox tick then auto highlight certain columns?

Stuart.d ✭✭
edited 12/09/19 in Formulas and Functions


We have a sheet called project milestones for managing the steps of LIVE manufacturing an installation projects. 

I'd like when our production manager selects a tick box on a specific row, that 4no columns within the row are automatically highlighted light green. 

The column "In production/ Approval Docs uploaded" Should be the driver, 

Then whenever a row is ticked, the "Project No"/ "Customer" / "PM" and "Project Ref" in that specifc row turn light green

Image attached 

Community.........How do I do this? 

Thanks in advance 

Snapshot of Milestones.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!