Conditional formatting an entire sheet?

I'm looking to set up a workplace roster on Smartsheet, to cover the 50-odd employees in our workshop.

  • each employee has their own column
  • date tracks row by row
  • each cell tracks daily rostered hours for each employee

I already have something of this sort set up, but I want to develop it an extra step or two so it will be suitable for the whole office to use. I want to highlight cells a different colour if they contain information other than working hours - AL (annual leave), RDO (rostered day off), PH (public holiday), TRN (training), Sick.... etc.


If I set up the conditional formatting rules as I understand them, I will need to generate hundreds of rules to cover the workforce, and this is not practical.


My question - Can conditional formatting rules be created that apply to an entire sheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!