Multiple conditions (from different columns) applying conditional formatting

Jason Christensen

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

Thanks

Andrée Starå

Hi Jason,

Yes, you can use an AND condition for the Conditional Formatting. Still, sometimes depending on the need, the criteria aren’t possible without using a so-called helper column and a formula.

Add a Condition

1. Click Conditional Formatting 

 in the toolbar to display the Conditional Formatting window.

1. Click the drop-down arrow 
2.  to the left of the rule in the Conditional Formatting window to view additional options.

2. To add more conditions to a rule, select Add Condition (AND).
3. This creates an “and” operator in the rule, indicating that multiple conditions must be met for the format to be applied.

More info:

https://help.smartsheet.com/articles/516359-conditional-formatting#modify

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!