Checkbox tick then auto highlight certain columns?

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

Find more posts tagged with

Manufacturing

Construction

Formulas

Project Management

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…