title: Incrementing cell reference number by 12 columns
body: <p>I have some cells that are coloured based on the value of some referenced cells in Excel:</p>
  
  <p><a href="https://i.stack.imgur.com/RwoNP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RwoNP.png" alt="Table of coloured cells"></a></p>
  
  <p>As you can see, 'A', 'B', and 'C' refer to several sheets within the workbook. So you type in the name of the sheet at the top row like 'A' (circled), and then the cells for rows a, b, and c colour themselves in based on the values of a table within that sheet. So for A:</p>
  
  <p><a href="https://i.stack.imgur.com/PER8I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PER8I.png" alt="Table of values to reference"></a></p>
  
  <p>All of those cells in the table are referenced via the INDIRECT and TEXT functions.</p>
  
  <p>My problem is that I currently have to make an absolute reference to the top row (i.e. 'A') in 'Summary' in order to pick out the right sheet (which is also named 'A'). But then I cannot copy and paste this to make another entry (e.g. 'D') without having to manually type in the cell for that entry for every colour formatting rule.</p>
  
  <p>So I want to say 'Excel, pick out the same cell 'A' while in the current entry (for rows a, b, c, and total), and then select the cell 12 columns along for the next entry' for every colour formatting rule. Is there any way of doing this?</p>
  
  <p>Hope this makes sense. And no, I'm not a fan of using Excel for this, but this is what I'm stuck with. Please feel free to ask for clarification. I cannot use VBA (as it is a security risk).</p>
  
  <p>An example of a colour formatting rule is, for row 'a', column '1':</p>
  
  <p>Turn green if the following is true: <code>=INDIRECT($E$8 &amp; "!" &amp; "C" &amp; TEXT(E14+1, "0"), TRUE)&gt;=a_Score_Upper</code> (where $E$8 refers to the entry's name, circled red above)</p>