title: Randomly assign cell background color based on unique cell texts
body: <p>I'm looking for some conditional formatting solution where <strong>a new cell background color is set to a unique cell text</strong>. The image below shows this.</p>
  
  <p><a href="https://i.stack.imgur.com/kel7z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kel7z.png" alt="enter image description here"></a></p>
  
  <p>The tricky part is that I won't know any of the values within the list beforehand.</p>