Macos – Excel: Conditional formatting if cell is not equal to one of multiple values

macosmicrosoft excelworksheet-function

Using Excel, I would like to conditionally highlight a cell, if the value of the cell itself is not one of several values.

The cell should be contain of the following percentages – 0%, 6%, 12% – or else it should be conditionally formatted to a red background.

Based on this answer, I would've thought that the below formula would work – but for some reason it doesn't.

=NOT(OR(D3=0, D3=0.06, D3=0.12))

D3 is the cell I want to enter a value into, and it's the same cell I wish to be conditionally formatted.

I create a conditional formatting rule, via New Rule > Style: Classic > Use a formula to determine which cells to format. I then paste the above formula into the formula/range selection field.

enter image description here

I get the error There's a problem with this formula:

enter image description here

Best Answer

enter image description here

Select required Data Range and write this Formula as New Rule and apply an appropriate color.

=NOT(OR(G142=0%, G142=6%, G142=12%))

Note, adjust cell reference in the Formula as needed.

Related Question