title: random color based on cell value(Name column)
body: <p>I need to have the formula or Macro which can give me below output.</p>
  
  <p>If you see below example. I need color row based on Name column.</p>
  
  <p>For example: Name A has 2 records both rows should be highlighted with the same color.
  I can do this with conditional formatting, but I have too many values in <em>name</em> column and this is the main reason I'm looking for macro.</p>
  
  <pre><code>INC-No  Host    Name
  INC1    x1      e1
  INC2    x2      e2
  INC3    x3      e3
  INC4    x4      e2
  INC5    x5      e5
  INC6    x6      e1
  INC7    x7      e3
  </code></pre>
  
  <p>Thanks
  Harsha</p>