title: if a cell has specific formatting, change another cell to a specific value
body: <p>if a cell has specific formatting or text, i need it to then tell another cell to be a specific value. see example picture <a href="https://i.stack.imgur.com/1qMZb.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>notice how because the cell is green and has white bold text, the cell right above it has a value of 2 and the red cell does not have a value.</p>
  <p>The same can apply if a cell is red with yellow bold text. if this is the case, it can subtract 1 point. if cell is yellow text and green background, no points are awarded or taken away. <a href="https://i.stack.imgur.com/ZkEu0.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>does anyone know how to accomplish this without having to manually do this every time?
  Thank you in advance.</p>