Conditional formatting problem

[MartinLiss]

I'd like to have a conditional formatting rule apply to cells with any of these values 10, 20, 30, 40, 50, 60, 70 or 80. I know that if there was just one value (for example 10) that I could use =C3:V8=10. I also know that I could create 7 other similar rules for 20, 30, etc, but how can I do it with just one rule?

[OptionBase1]

This should work.

=IF(AND(AND(V8 >= 10, V8 <= 80), MOD(V8,10) = 0), C3,0)

[MartinLiss]

Thanks, but for readability purposes I'd prefer a formula that refers to the specific values.

[OptionBase1]

Ok. Untested.

=IF(OR(V8=10, OR(V8=20, OR(V8=30, OR(V8=40, OR(...)))))))), C3, 0)