Conditional formatting - OR condition?

I need to use conditional formatting to specify an OR condition on multiple columns. I only see the AND condition option. Without an OR condition, I have to create multiple conditional formatting rules. Is there any way to get an OR option for the conditional formatting? Why would there be just an AND option and not an OR option? Any help would be appreciated. Thx!

Best Answer

  • John_Foster
    John_Foster Community Champion
    Answer ✓

    Hi @DTPM,

    I have had the same requirement on a sheet that is used within the business. To work around this, I have created a helper column which uses an OR formula that gives a 1 or 0 depending on whether the conditions have been met and I then set the conditional formatting from the helper column rather than the raw data columns.

    Hope this helps.
    John

Answers

  • John_Foster
    John_Foster Community Champion
    Answer ✓

    Hi @DTPM,

    I have had the same requirement on a sheet that is used within the business. To work around this, I have created a helper column which uses an OR formula that gives a 1 or 0 depending on whether the conditions have been met and I then set the conditional formatting from the helper column rather than the raw data columns.

    Hope this helps.
    John

  • DTPM
    DTPM ✭✭

    Ah, that makes sense. Creative workaround, John! Nice. Thank you for the tip!