Conditional formatting for multiple numbers

[Mitch21]

I want to highlight certain numbers in the list below.

Here are the numbers I care most about:
0, 15, 20, 25, 30, 40, 45, 60, 75, 80, 90

My preference would be to highlight any number not listed above in red.

Another option would be to highlight any number that IS on the list above in green.

How can I write a conditional formatting formula for this?

Thanks!

0
15
17
20
26
25
55
30
40
45
88
60
75
80
105
156
90
111
200
115

<tbody>
</tbody>

 

[Mitch21]

OK, those seem like valid numbers. Perhaps you are not setting up the Conditional Formatting properly.

Try it again, using these steps:
1. Select the entire range that you want to apply this to.
2. Go to Conditional Formatting, select New Rule, and select the "Use a formula to determine which cells to format" option
3. Enter the formula as it applies to the very first cell in your selection. This part is very important! The ranges used in your formula must correspond to the first cell in your selection. Excel is smart enough to adjust it for the rest. So, if you select cells A2:A100, then your formula should reference cell A2.
4. Choose your Formatting option (color cell or text).
5. Click OK.

I see people mess up step 3 quite often. They will select the entire column A, but then write the formula referencing A2 instead of A1, because A1 contains headers.
The formula MUST correspond to the first cell in your selection.

This worked very well, thank you. Not sure exactly what I was doing wrong before, but this fixed it. Thanks so much!

 

[Joe4]

You are welcome!

 

[Peter_SSs]

Sounds like the actual implementation was the likely problem with my suggestion too then.

 

[Mitch21]

Sounds like the actual implementation was the likely problem with my suggestion too then.

Yes, most likely. I'm sure user error is the root of many of the issues on this board!