nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Conditional Formatting when changes are made

Leann Gibson

How do you highlight when a change is made to any row or column? e.g. if someone changes the due date, I want the entire row to be a color.

Find more posts tagged with

Conditional Formatting

Comments

Nick Burrus

Hello Leann! You cannot do this automatically if a change is made in a row, to be colored. But, there is a feature built-in that does this!

Check this image out here:

Highlight

Do you see the marker next to the table and hyperlink buttons? That is called a highlight change. It will highlight any cell that has been changed since you last looked at the sheet.

Thanks,

Nick

Stria, LLC Signature

Andrée Starå

Hi Leann,

To add to Nicks excellent advice for the Highlight Changes.

It's possible to to have a row change color when the due date changes but the date have to be set either in another column or in the Conditional Formatting rule.

Would that work?

Let me know if you have any questions!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Lost access to all sheets – account appears empty despite correct email & region
Hi everyone, I’m experiencing an issue where all of my sheets have suddenly disappeared from my account. Here’s what I’ve already checked and tried: I’m logged in with the correct email address I’ve confirmed I’m in the correct region I’ve checked my Deleted Sheets folder I’ve tried logging in and out in all possible ways…
Proof Comments
Is there a way to pull comments out of a proof and have them show up as a column on the main sheet? They don't come up in the conversation area, but they're on the activity log. I just don't want to overlook a comment on something if they don't tag me. I'm looking for any way to put a signal on the sheet that there's a…
Is there a template for a Decision Matrix?
I am looking for a decision matrix, preferably weighted. Is there such a thing in Smartsheet currently today, or is this something that I have to build?