CONDITIONAL FORMATTING CELL WITH MULTIPLE VALUES

Question

CONDITIONAL FORMATTING CELL WITH MULTIPLE VALUES

Anonymous

I am wanting to know if in Excel and specifidally conditional formatting, is it possible to have multiple values that could be in a row? This is a small sample of what I am referring to.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

1 answer

Answer 1

From your screen shot, I am assuming that you mean multiple values in a Column and not in a Row as per your post.

Select the column
Selct Conditional formatting
Select Use a formula to determine which cells to format
Enter the following formula in the field under "Format values where this formula is true"

= OR(B1=57,B1=53,B1=99)

Select Format and set the formatting required.

Note that the formula is created for the first cell of the "Applies to" range which is B1 when it is the entire column and Excel applies it to the remaining cells of the range. If you specify a specific range like B2:B31 then B2 is the first cell of the range so substitute B2 for B1 because the first cell of the "Applies to" Range is B2.

Share via

CONDITIONAL FORMATTING CELL WITH MULTIPLE VALUES

1 answer