Conditional Formatting Not Working on New Sheets

Renee Sprague

Hello,

Existing sheets (grids) the existing conditional formatting rules are working.

Any new sheets (grids) that I create, the conditional formatting is not working.

My rule is very basic.

Any ideas?

Thanks - Renee

Mike Wilday

Can you share a screenshot of your new sheet and the conditional formatting rule?

Renee Sprague

Hi Mike,

Moments after I submitted this, I got it working.

1. I was selecting the color to change for the Task Bar rather than the paint fill. That solved issue #!.
2. I had to re-order my tasks so that Status = Resolved trumped Priority.

When the Priority = P1, the entire row turns red.

When that issue Status changes to "Resolved" the entire row turns green

Thanks

Mike Wilday

Awesome. Yes, glad you figured it out. Smartsheet conditional formatting does apply formatting from top to bottom.