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!

Paul Newcome

And the answer to your second question is Yes. You can create as many Conditional Formatting rules as you want that contain the same format. The easiest way to do this if you are only changing one condition would be to set up the first one, clone it, then tweak it.

Andrée Starå

@Paul Newcome Thanks for answering the second question!

@Jason Christensen I missed the second question, sorry about that!