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.
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:
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
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
Hi! When creating a dropdown list field in a form, I am unable to separate my values as in nothing happens when I press Enter to type another value on a new line. I have tried different browsers as well as clearing my cookies/cache. Are there any other ideas or a work around for this?
Hello, I am working on a workflow in data shuttle where it offloads any rows that have the helper box checked. Most of these rows will also have attachments that are filled with data. I find that when I offload, the attachments do not come over. Is there a way to include/ download/ offload/ export/ the attachments as well?…
I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater…
