Conditional formatting for an entire row based on one cell

[lzweifel]

Hi... please someone help!!

I have set A1 with a drop down of four text choices and a conditional format to change the color based on which ever text is chosen. Now, when a certain drop down text is chosen and the color changes I need the entire row to also change to that color.

So, basically... I can't figure out the formula or conditional format to change the entire row based on that one cell drop down. I do need, however, the text in the rest of the row to remain as is and editable.

 

[lzweifel]

Thank you Thank you THANK YOU!!!!!! So very very much appreciated, wish I could buy you a beer!

 

[Weazel]

you're welcome, glad you got it sorted out

 

[lzweifel]

Hi... can you send me the link again to do this?

 

[Weazel]

see if this works for you...

https://app.box.com/s/9g33ttb6ley7ipt7zguvq00lctm8afkl