Remove conditional formatting from rows

Hi,

Just wondering how to remove conditional formatting from specific rows. I am fairly new to using smartsheet but it seems like you can only do conditional formattings to certain columns but what if you wanted specific rows to not have the rules?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Tina Truong

    Would you be able to provide a little more information, for example a screen capture of how your sheet is set up & what rows you want excluded (but please block out any sensitive data!).

    You would want to adjust the criteria for the Conditional Formatting so that it doesn't include these rows in, perhaps by adding in an AND statement.

    So, for this example, I want certain cells to turn red but only if there's a red status ball in one column AND if there's a checkbox in another:

    I added in the AND statement by clicking on the dropdown arrow on the left and selecting "Add Condition (And)"

    You can learn more about Conditional Formatting in our Help Center (see here).

    I hope that helps!

    Cheers,

    Genevieve