Conditional Formatting: everything but "X", "Y", or "Z"

[reneev]

We are trying to capture errors in rates. Rates can either be 0, 36.12 or 40. How do I conditional format a cell if it's anything other than one of those numbers? And can it be expanded for additional numbers if I have more than three rates

 

[DSCfromCFA]

Thanks Claire,

I currently suffer from a bad case of wanting to be helpful but not knowing quite enough on most matters.

Cheers

shane

 

[ClaireS]

Me too, I am in awe of so many of the contributors on this board, and I find it a great learning resource!