title: Apply Conditional Formatting to Cell on Left
body: <p>I have a spreadsheet with 15,000 rows and 30 columns, and have applied a conditional formatting to column X to color it when it contains a certain text. This works as expected; however, I want to apply this same formatting to the cell immediately to the left (column W) as well. Is this possible? </p>
  
  <p>Based upon what you say below, this is what I tried:
  <a href="https://i.stack.imgur.com/8dz7f.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8dz7f.png" alt="enter image description here"></a></p>
  
  <p>The formatting is not working. Is the lookup formula not correct?</p>
  
  <p>Note: Since I never know how many rows I may have at any time, I am trying to apply the formatting to the entire column instead of a specified range of cells.</p>
  
  <p>EDIT:</p>
  
  <p>The $X1 trick works!
  <a href="https://i.stack.imgur.com/DwUwL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DwUwL.png" alt="enter image description here"></a></p>
  
  <p>You are the BEST! Many thanks to all of you!</p>