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.

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

`,`

and the delimiters you should be using? what happens if you use`;`

instead?) – cybernetic.nomad Oct 18 '18 at 20:17`;`

. It might be Mac thing, or a localization issue. This works:`=NOT(OR(D3=0; D3=0.06; D3=0.12))`

. – Winterflags Oct 18 '18 at 20:20