title: Excel Conditional Formatting based on Other Column
body: <p>I have two columns in Excel as shown on the picture below. </p>
  
  <p><img src="https://i.stack.imgur.com/rGfdW.png" alt="enter image description here"></p>
  
  <p>I need to apply conditional formatting in this way:</p>
  
  <p>if row in B column contain "1", the cell A on the same row should change its color. This needs to be applied only for the cell in A column, not whole row. Is there any option how to do this?</p>