title: Color entire row based on the value of 2nd cell in that row?
body: <p>I have a list in Excel and I need to format rows based on the value in the cell 2 of that row. This is how data looks like</p>
  
  <pre><code>No. | Name | Other data | Other data 2 | Date | Date 2 |
  </code></pre>
  
  <p>For example, <code>if Name=John Tery =&gt; color row as Red</code>, <code>if Name=Mary Jane =&gt; color row as Pink</code>, etc.</p>
  
  <p>I tried using conditional formatting, but I did not know how to make this work. I have very little experience with such tasks in Excel. </p>
  
  <p>Can anyone help?</p>
  
  <p>PS. all name are two-word names</p>