highlight multiple cells based on one cell text

[jrisebo]

I want a series of cells to hightlight if a certain cell has a certain text. So, if M8 has the word "text" in it, I want B8 to M8 to be highlighted. But i want it to apply to the whole column of M, so if M16 has the same text, B16 to M16 highlight.

Cant figure this one out!

 

[Joyner]

For your conditional formatting highlight all of the cells from B8 to M16, for example, and formula should be =$M8="text"

 

[jrisebo]

For your conditional formatting highlight all of the cells from B8 to M16, for example, and formula should be =$M8="text"

Thanks, that worked!