title: Google Sheets Conditional Formatting Issue
body: <p>I am making a google sheet to track attendance for a team. I want the row with the name to highlight a specific color when a checkbox is on. I managed to write something that works for the specific row I'm working in, but any time I try to copy it over to other rows the range is just adjusted, so any time any checkbox from a column is on it highlights all the rows. Attached are pictures that show what I want it to do. I just need help figuring out how to copy this to other rows and keeping them all separated.</p>
  
  <p>The code that is in each conditional formatting is this:</p>
  
  <pre><code>=$B2=True
  =$C2=True
  =or($D2,$E2)=True
  </code></pre>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1zwkuJOCBPIIoQ7cp0bV5IvidMVwdeIC0dShdjwKMSkE/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1zwkuJOCBPIIoQ7cp0bV5IvidMVwdeIC0dShdjwKMSkE/edit?usp=sharing</a></p>
  
  <p>I think the issue is with the code itself because when I copy it adds the new range, but the code stays the same.</p>
  
  <p><img src="https://i.stack.imgur.com/nzZJZ.png" alt="Sheet"></p>
  
  <p><img src="https://i.stack.imgur.com/PDnWE.png" alt="Present"></p>
  
  <p><img src="https://i.stack.imgur.com/4kmFf.png" alt="Absent"></p>
  
  <p><img src="https://i.stack.imgur.com/by1Nc.png" alt="Late"></p>
  
  <p><img src="https://i.stack.imgur.com/T9ZGo.png" alt="Conditional Formatting 1"></p>
  
  <p><img src="https://i.stack.imgur.com/1rQaX.png" alt="Conditional Formatting 2"></p>