Multiple conditions (from different columns) applying conditional formatting

1 Can I do conditional formating using more than one criteria (different Columns)

We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the total in red.

is there a way to make 2 conditions for the same formatting rule? example if frequency is '30X/Month' and month column is <30, highlight red

If Frequency is '4X/month' and month Column is '<4' turn background red or highlight red

etc for 1X/Month



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!