Alerts

Robert Hall

How do I change a row color if project is past due

Alison

Hello Robert,

Thanks so much for this question.  The best way to do this would be to set up a Conditional Formatting rule based on the Due Date column you have.  If your Due Date column is a date-type column, you'll be able to set up the rule to change the color of the cell or the row if the date is in the past.  I've attached a screenshot of this.

A tip that I have is to make sure that you're selecting the paint bucket icon since you're looking to have the background color changed; the Task Bar option will only change the color of a Gantt taskbar, so you won't see any changes on your regular grid view.

Kind regards,

Alison

Smartsheet Support