1

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 

Functionality
Department

Comments