title: Cell formating based on other cell value google sheets
body: <p>I have 2 sheets the first one is Orders and second one is the ShippingDoc.</p>
  
  <p>At Shipping doc, I have Cell C2. In that cell I choose/write  ID from range of A7:A from Orders.</p>
  
  <p>Is there a way if I choose example ID 1 at C2 then automatically A7 at Orders to change background to green. Also if I change the ID to 2 the A8 to be green and to not delete the A7 color.</p>