Conditional Formatting- on specific values

**johnnywinter** · 02-12-2009, 09:25 PM

Can Conditional Formatting be set on multiple values? I cannot get this to work with any formula, the cell values are not between two values.

For example:

for value = D or R, or X change color to green

(I would have another condition within a range F to Q)

**JBeaucaire** · 02-12-2009, 09:32 PM

Do you mean if the cell value is equal to the letter "D" or "R" or "X"? If the cell your setting formatting in is A2, then that conditional format would be:

=OR(A2="D",A2="R",A2="X")
...and set the color to green.

Or were you referring to columns? So if the value in A2 equals the value in D2 or R2 or X2, then you want the cell to turn green? That conditional format would be:

=OR(A2=D2,A2=R2,A2=X2)
...and set the color to green.

**johnnywinter** · 02-12-2009, 09:52 PM

I am trying to Conditionally Format a Cell at time of input.

I tried your example using: FORMAT - CONDITONALLY FORMATTING -

Cell Value Is Equal To and input this : =OR(G15="D",G15="R",G15="X")

It would not take it. I also tried the same formula with "Formula Is"

I also tried it without the reference to G15- same result.

I have no problems with contiguous range or for 1 value, but I have number of non-contiguous values that I need the cell to format in same color upon input.

**JBeaucaire** · 02-12-2009, 10:21 PM

Those are formulas, and it works perfectly as shown in your post:

Condition1: Formula Is: =OR(G15="D",G15="R",G15="X")
...and set your color.

I'm looking at a sheet right now that is working great with that formula.