title: Excel conditional formatting based on multiple cells
body: <p>I am having trouble coming up with a usable conditional formatting formula in Excel to highlight patterns.  </p>
  
  <p><a href="https://i.stack.imgur.com/9iM8Z.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9iM8Z.jpg" alt="Starting Sample Data"></a></p>
  
  <pre><code>Phase   Sample1 Sample2 Sample3 Sample4 Sample5 Sample6 Sample7 Sample8
  {0-}    lm  ll  lm  lm  ll  lm  ll  lm
  {0-}    lm  ll  lm  lm  ll  lm  ll  lm
  {1-}    lm  ll  ll  lm  lm  ll  lm  ll
  {0-}    lm  ll  lm  ll  ll  lm  ll  lm
  {1-}    lm  ll  ll  lm  lm  ll  lm  ll
  {1-}    lm  ll  ll  lm  lm  ll  lm  ll
  {0-}    lm  ll  lm  ll  ll  lm  ll  lm
  {1-}    lm  ll  ll  lm  lm  ll  lm  ll
  {1-}    lm  ll  ll  lm  lm  ll  lm  ll
  </code></pre>
  
  <p>(tsv format)</p>
  
  <p>Given the sample above, the formatting I want to do, in English is:</p>
  
  <p>"If, for every row in the spreadsheet, the cell in column A="{0-}", highlight any cell in the same row that contains "lm", else, highlight any cell containing "ll" " </p>
  
  <p>The desired outut would look something like this</p>
  
  <p><a href="https://i.stack.imgur.com/dZQPX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dZQPX.jpg" alt="enter image description here"></a></p>
  
  <p>PS: For some background (that isn't quite relevant for the question here, but is more for anyone in the future who might google search for a similar question): I am evaluating a genetic map from an outcrossing population based on the output of the program JoinMap. These calls are coded based based on the underlying genotype and the calculated phase is given in the first column.  I am, in essence, attempting to re-create the JoinMap output in the program itself  but in Excel, so it can be edited.</p>