Checkbox tick then auto highlight certain columns?

Stuart.d

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 

Andrée Starå

Hi Stuart,

You would do this thru conditional formatting.

Please see the attached link/screenshot for more information.

EDIT: Added how to do it more in detail. https://cl.ly/c05159

https://help.smartsheet.com/articles/516359-conditional-formatting

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting