title: Changing values in a specific cell based on other cell/row inputs
body: <p>Hi I'm fairly new to formulas and excel but this is one of the problems I have encountered.</p>
  
  <p>I have been using 2 conditional formatting formulas as follows</p>
  
  <ol>
  <li><p><code>=INDIRECT("I"&amp;ROW())="Del"</code></p></li>
  <li><p><code>=INDIRECT("I"&amp;ROW())="Sum"</code></p></li>
  </ol>
  
  <p>Where the first formula simply highlights the row grey if del is in the I column of that row, is there also a way of making it change say the K column to 0 if column H in that row is 0?</p>
  
  <p>And for the second formula which also highlights the row another color based on sum input in the given column of that row, is it also possible to change K column of that row to match the value of H column of the given row.</p>
  
  <p>I know they would be similar but I needed to make it so formula one would only zero the K column in the given row if I column had "del" and H column of the row had Zero.</p>
  
  <p>And for the second formula the values would only change in column k of the given row if "sum" was in the I column. Anything else needs to stay unformatted unless these changes are implemented.</p>
  
  <p>I am unable to add a formula the the cells in question as these are overwritten with an button clicked event which inputs data into this field.</p>
  
  <p>any information is appreciated, formula or VBA.</p>