Conditional Formatting of multi cells

[wmtsub]

I have some conditional formatting created thru - conditional format - highlight cells rule - equal to.
They apply to $B:$B. I would like to change the results so if the cell in row b equals the condition the highlight would affect of not only that cell but the cells adjacent in columns a and c.

 

[Joe4]

Re-do your Conditional Formatting like this:
Select columns A, B, and C, and then apply the following Conditional Formatting Formula:

=$B1 = [I]some value[/I]

and choose your formatting highlight color.
By using the "$" in front of the column B reference, you are locking that down and telling all of columns A, B, and C to look at the value in column B.

 

[wmtsub]

That gives me a syntax erro. Does notwork

 

[Joe4]

You need to replace "some value" with whatever value you are trying to see if that cell is equal to.
If you still get an error, please post the exact Conditional Formatting formula you are trying.

 

[wmtsub]

=$b1= house

 

[Joe4]

Conditional Formatting formulas follow all the same rules as any other Excel formulas. Literal strings must be enclosed in quotes, i.e.

=$B1="house"

If it was a number, it would not need quotes around it.

 

[wmtsub]

Tks.