title: Google Sheets Macro Color Cells
body: <p>Is there a way to write a continuously running script in google sheets where it scans the sheet to find any cell with a certain text and the color that and the adjacent cell a certain color?</p>
  
  <p>So here's my sheet</p>
  
  <pre><code>------------------------------------
  | ColA            | ColB           |
  ------------------------------------
  | CellA1          | CellB1         |
  ------------------------------------
  | CellA2          | CellB2         |
  ------------------------------------
  | CellA3          | CellB3         |
  ------------------------------------
  </code></pre>
  
  <p>I want to find the row with <code>ColA = 'CellA1'</code> and then color both that cell and the adjacent cell, <code>CellB1</code>, a particular color.</p>
  
  <p>And I want to make it continous so that when I insert a new row and type in <code>CellA1</code> for <code>ColA</code> then it'll automatically color it a certain color after I hit enter. </p>