title: Conditional Formatting Based on Single Cell Across Columns and Rows
body: <p>I'm trying to find a single formula for conditional formatting based on a single cells value next to a section of cells. This would include both rows and columns, as well as sections next and below each section. This section would check to see if the single cell contains a particular name, which would be corresponded to a particular color.</p>
  <p>In my example sheet, I have single cells containing a name (B2, H2, B7, H7), which corresponds to the ranges next to the cell (B2 -&gt; D3:F5, H2 -&gt; J3:L5, B7 -&gt; D8:F10, H7 -&gt; J8:L10). I'm looking for single formula that would apply to all ranges checking for a name, for example =$B$2=&quot;John&quot; would be the color RED in each of the cell sections (D3:F5, J3:L5, D8:F10, J8:L10).</p>
  <p>Is it possible to have a single formula for both sections horizontally AND vertically, or can it only be horizontally OR vertically? The names in B2, H2, B7, H7 can interchange, so I'm trying to make the colored regions dynamic.</p>
  <p>Test Sheet: <a href="https://docs.google.com/spreadsheets/d/1LLXNtMbwyDSe3Kl3y_q_l6hEsmpSGXX1h26-Ad5X8JM/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1LLXNtMbwyDSe3Kl3y_q_l6hEsmpSGXX1h26-Ad5X8JM/edit?usp=sharing</a></p>
  <p><a href="https://i.stack.imgur.com/BU5oX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BU5oX.png" alt="enter image description here" /></a></p>
  <p>Please let me know if that makes sense? Thanks!</p>