Why doesn't my conditional formatting in excel work?

Question

I have 6 cells.

I want to make all cells whose text isn't "a", "b" or "c" have a red background colour. I tried using a formula to make a new formatting rule. My formula is: =NOT(OR("a","b","c")). However, after I click OK, nothing happens.

You need to use this =NOT(OR(C3="a",C3="b",C3="c")) Where C3:C7 -> "a","b","c","d","e" — Mayukh Bhattacharya
– Mayukh Bhattacharya, Commented Mar 7, 2022 at 23:03
or put the list in another range and you can use: =ISNA(MATCH(C3,$Z$1:$Z$3,0)) where $Z$1:$Z$3 contain the a,b,c — Scott Craner
– Scott Craner, Commented Mar 7, 2022 at 23:11

Mayukh Bhattacharya · Accepted Answer · 2022-03-07 23:11:42Z

1

Just for clarity, refer the image below,

Formula needs to be used in Conditional Formatting

=NOT(OR(C3="a",C3="b",C3="c"))

Follow the steps:->

• Select the list range,

• From Home Tab, --> Under Styles Group --> Click Conditional Formatting,

• Click New,

• New Formatting Rule Dialog opens,

• From New Formatting Rule Dialog Box --> Select --> Use a formula to determine which cells to format

• Enter the above formula, in the edit the rule description,

• Click the Format Button --> From Fill Tab --> Choose desired color,

• Press Ok --> Ok

answered Mar 7, 2022 at 23:11

Mayukh Bhattacharya

29.2k9 gold badges31 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why doesn't my conditional formatting in excel work?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related