title: Conditional formatting on all duplicates
body: <p>I'm trying to make a formatting rule in Business Intelligence/Web Intelligence that changes background color of all duplicates based on one field (address id). The best I've got so far is this:</p>
  
  <pre><code>=Previous([Address Id])=[Address Id]
  </code></pre>
  
  <p>But that code only changes the background color on the following duplicate only, not the duplicate before it.</p>
  
  <p>Example:</p>
  
  <pre><code>Addr.Id   Name
  123       John
  234       Henry [not marked]
  234       Harold [marked]
  345       Lucas
  </code></pre>
  
  <p>I want to change the background color of both of the rows with Addr.Id=234.
  My Google Fu hasn't come up with any info on how to compare the self-value with the next value. I only found information about "Relative Value" but this require slicing by dimension (which doesn't work for me).</p>
  
  <p>Is this possible?</p>