title: How to conditionally format based on neighbour cell text?
body: <p>I'm trying to use conditional formatting on a table like this:</p>
  
  <pre><code> ╔════════╦════════╗
   ║ Editor ║  Type  ║
   ╠════════╬════════╣
   ║ john   ║ Fun    ║
   ║ doe    ║ Travel ║
   ║ mark   ║ Movies ║
   ╚════════╩════════╝
  </code></pre>
  
  <p>where I need to color both columns according to Editor rows content.
  For example, if editor is <code>john</code> both Editor and Type need to be green, if <code>doe</code> red, etc., etc.</p>
  
  <p>Of course in <code>Editor</code> column using simple "text is" conditional works flawlessly but in <code>Type</code> I tried indirect, address and several other formulas in the "Custom formula is" field.</p>
  
  <p>What do I need to do?</p>
  
  <p>Additionally, the columns repeat horizontally, like this:</p>
  
  <pre><code>╔════════╦════════╦════════╦════════╗
  ║ Editor ║  Type  ║ Editor ║  Type  ║
  ╠════════╬════════╬════════╬════════╣
  ║ john   ║ Fun    ║ john   ║ Fun    ║
  ║ doe    ║ Travel ║ doe    ║ Travel ║
  ║ mark   ║ Movies ║ mark   ║ Movies ║
  ╚════════╩════════╩════════╩════════╝
  </code></pre>
  
  <p>So I need a solution compatible with this.  </p>
  
  <p>Any ideas?</p>