Remove one of the "if and" conditions in conditional formatting rule

Hi there.

I do not know how to remove one of the conditions if I have more then one.

Since I do not know how, I have to delete the rule and make a new one, loosing the already selected formats and cells.

Who can help on this one?

Regards,

Vincent

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Unfortunately the only way I have found is to create a new rule and delete the old one. I usually do it in that order so that I can make sure I am setting up the same formats before deleting the rule I no longer want to keep.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers