title: Conditional formatting rows to change color of row based on drop list selection, in Excel 2007
body: <p>I am lookg for some help with what I thought would be an easy task. I have a worksheet of 200+ rows by 12+ columns. Based on a drop list selection in of the columns, I would like that corresponding row to change color. I have 4 choices with 1 color each. I was able to do it the first column using conditional formating with a new formula:</p>
  
  <p>ex. =IF($Y$2="Multimedia", TRUE, FALSE)</p>
  
  <p>then the format I selected the color yellow. So then row 2 will turn yellow.</p>
  
  <p>I added the other three formulas and it works perfectly for the first row but I cannot figure out a way to pull down to the entier sheet. When I do so, every row roots itself to the first row. How can I use this formatting in the entier sheet without having to do manually? </p>
  
  <p>Thanks</p>