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
Community.........How do I do this?
Thanks in advance