Checkbox tick then auto highlight certain columns?

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

Hi, 



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

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!