Conditional formatting for entire sheet instead of columns?


I have a grid set up to track the status of 12 different steps in a process for 10 items. The rows list the individual items, the columns track the status for each step. I want the cells to light up based on the status - Not Started = grey, In Progress = yellow, Complete = green, Having Issues = red. Is there a way to do a blanket conditional formatting for the entire sheet instead of column by column, creating 48 formatting rules?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!