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:
Best Answer
Select required Data Range and write this Formula as New Rule and apply an appropriate color.
Note, adjust cell reference in the Formula as needed.