title: Excel: Conditional formatting more (text) instances inside column or whole row
body: <p>I have one workbook with more sheets (queries) inside, which are updated regularly. 
  Among the columns there is a specific one (for groups) where there are many instances in <strong>Column D (Vargrouptext)</strong> as it is shown on the picture. You can see it is repetitive, and it has many of those options. Is there a quicker way to somehow "group" them by color or format them, but not that I go manually one per one, to select column and then manually to do? Is there a way to apply that conditional format on a whole row??</p>
  
  <p>for example:</p>
  
  <pre><code>CPS101  CSP MODEL
  
  CPS102 CSP MODEL
  
  CPS103 CSP MODEL 
  </code></pre>
  
  <p>To have whole row (Column A to D) formatted into some color, but to apply that on all instances from Vargrouptex with different color per instance? </p>
  
  <p>For example I can apply this format painter or copy cond.format to make a bit quicker but I still have to click X times. </p>
  
  <p><a href="https://i.stack.imgur.com/Pn3lE.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Pn3lE.jpg" alt="enter image description here"></a></p>