Conditional formatting if a cell does not equal one of three values

Question

I have a dataset as below:

I want to apply conditional formatting that will format a cell if the value in that cell is not 100, 50 or 0 (ie I want it to pick up A5 and format it)

I'm new to conditional formatting and haven't been able to figure this out yet. Does anyone have any suggestions as to how I could achieve this?

Answer 1

1. Remove any previous attempts at a Conditional Formatting Rule.
2. Select A2:C5 and use Home ► Conditional Formatting ► New Rule.
3. Choose Use a formula to determine which cells to format and supply the following for Format values where this formula is true:
           =not(or(A2=0, A2=50, A2=100))
4. Click Format and select some formatting change.
5. Click OK to accept the formatting and then OK again to create the new rule.

You results should resemble the following.