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!
<tbody>
</tbody>
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>