Change Row or Cell Colour

GeorgeM

Hi team,

I have a running annual calendar of events and activities and would love to be able to automatically change the rows, or if not a row, the cell with the event names' color to indicate that the event has passed.

I have columns that show event start dates and ones with event end dates, so a formula or workflow that changes the color of the row or even a single cell, preferably the cell with the name of the event (which is in a separate column), once the end date is reached or passed.

Thanks for your awesome help as always

Paul Newcome

Sounds like you may be looking for Conditional Formatting.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Andrée Starå

Hi @GeorgeM

I hope you're well and safe!

You'd use conditional formatting for that.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Sounds like you may be looking for Conditional Formatting.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Andrée Starå

Hi @GeorgeM

I hope you're well and safe!

You'd use conditional formatting for that.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

GeorgeM

That was easy enough, almost feel silly for asking. Thanks

Paul Newcome

Happy to help. 👍️

Andrée Starå

@GeorgeM

Everything is easy when you know.

You're more than welcome!