title: OnEdit & OnChange at Google Sheets script API
body: <p>Well, i have a simple problem...</p>
  <p>I made a inventory management tool, that extracts info from other sheet and blocks the cell so the players can't edit the formula. I already have this onEdit command, but when i edit in the shet ITEM and go to CHAR, the formula update doens't trigger the event.</p>
  <p>The players edit a cell on sheets ITEM, and get loaded on the sheet CHAR. And both should trigger the same script, no problem if twice. This is a item grade coloring system.</p>
  <pre><code>function onEdit(event){
    var ss = event.range.getSheet();
    var changedCell = event.source.getActiveRange();
    
    var c = event.value;  // We know we edited cell, just get the value
    var background = 'black'; // Assume 1 &lt;= c &lt;= 2
  
      if (ss.getName() == &quot;CHAR&quot; || ss.getName() == &quot;ITEM&quot;) {
  
      if (c.endsWith(&quot;1*&quot;)) {
      background = 'black';
      }
      else if (c.endsWith(&quot;2*&quot;)) {
      background = '#cccccc';
      }
      else if (c.endsWith(&quot;3*&quot;)) {
      background = '#00ff00';
      }
      else if (c.endsWith(&quot;4*&quot;)) {
      background = '#0000ff';
      }
      else if (c.endsWith(&quot;5*&quot;)) {
      background = '#9900ff';
      }
      else if (c.endsWith(&quot;6*&quot;)) {
      background = '#ff00ff';
      }
      else if (c.endsWith(&quot;7*&quot;)) {
      background = '#ebc49d';
      }
      else if (c.endsWith(&quot;8*&quot;)) {
      background = '#ff9900';
      }
      else if (c.endsWith(&quot;9*&quot;)) {
      background = '#ff0000';
      }
      else if (c.endsWith(&quot;10*&quot;)) {
      background = '#00ffff';
      }
  
    changedCell.setFontColor(background);
  }
  </code></pre>
  <p>The extract formula is this per example:</p>
  <pre><code>=IF(ITEM!B66; ITEM!C66; &quot; &quot;)
  </code></pre>
  <p>If a checkbox on item is marked, the item shows a name, or not.</p>
  <p>Is there anyway so it can run on the formula update or change?</p>