title: How do I conditionally format cells based on an indirect formula that references "moving" cells
body: <p>Stackoverflow community,</p>
  
  <p>I'm using Excel '10.  I currently have an indirect formula that references 4 cells to determine the x,y coordinates for a sum range.</p>
  
  <p>Formula: =IFERROR(SUM(INDIRECT(G27&amp;G26):INDIRECT(H27&amp;H26)),"No Records")</p>
  
  <p>How do I use conditional formatting to highlight the cells that the formula is summing?</p>