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


Thanks

Answers

  • Andrée Starå
    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.
    1. To add more conditions to a rule, select Add Condition (AND).
    2. This creates an “and” operator in the rule, indicating that multiple conditions must be met for the format to be applied.

    More info:


    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    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.

    thinkspi.com

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Paul Newcome Thanks for answering the second question!

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.