title: Using defined names in conditional formatting
body: <p>I previously set up the conditional formatting so it would prevent duplicates but have realised that certain text in the cells will have to be there so I don't want it flagging up.</p>
  
  <p>I have created a list of names and defined them as "Names", the cells should only flag up if the same names are in multiple cells. Is there a way of doing this?</p>
  
  <p>If this doesn't make sense here is an example.</p>
  
  <p>Defined Name = Name</p>
  
  <p>Jack</p>
  
  <pre><code>Cell 1  Cell 2
  ABC     ABC
  </code></pre>
  
  <p>I don't want this to show up as a duplicate.</p>
  
  <pre><code>Cell 1 Cell 2
  ABC    ABC
  Jack   Jack
  </code></pre>
  
  <p>This should flag up as a duplicate as the text "Jack" is in my defined list.</p>
  
  <p><a href="https://i.stack.imgur.com/AwXqg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AwXqg.png" alt="These cells shouldn&#39;t show red "></a></p>
  
  <p><a href="https://i.stack.imgur.com/rvbaE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rvbaE.png" alt="The cells should only go red when the same persons name is allocated on the same day but in a different area"></a></p>
  
  <p>In the first picture the cells shouldn't go red</p>
  
  <p>The cells should only go red when the same persons name is allocated on the same day but in a different area (see picture 2)</p>