Conditional formatting with OR function

Question

What I need is to color cells background if they match one of various given strings.

In my case this will be Column A containing values A1 = 1.08, A2 = 2.08 (second day of August, etc.)

What I'm trying to do is to change the background color of all weekend days by just specifying it like that:

Conditional Formatting > New Rule > Use a formula to determine which cells to format.

And I'm trying to use the OR() function, which, however, doesn't seem to be working (on the range of my values) like that: =OR("1.08";"2.08";"9.08";"10.08" ...).

What works for me is: Conditional Formatting > New Rule > Format only cells that contain > Cell Value > equal to > ... (but in this case I'd have to make many rules that have the same formatting which is not really what I'm into, but for different values.

Please help me out.

Answer 1

Here you go.

Conditional Formatting > New Rule > Use formula to determine which cells to 
format > formula =OR(A1 = 1.08,A1 = 2.08,A1 = 9.08,A1 = 10.08)

and select the desired format colour

Then Again

Conditional Formatting > Manage Rules > Applies to 

There give the range of selection you want to apply this formula. Done!!