I've read a lot about highlighting duplicates, or all values that appear x times - but my problem is a little more complex than that.
I want to only highlight cells that appear 3+ times (excluding the first two occurrences).
For example:
<tbody>
</tbody>
In the above example, only the bottom row of cells should be highlighted as they are the 3rd instance of "Jim" and the 3rd instance of "Bill". I want the first two of any string to not be highlighted.
Is there some way to do a rolling "Count" conditional formatting that will check cells sequentially from top left to bottom right in a given range?
I want to only highlight cells that appear 3+ times (excluding the first two occurrences).
For example:
Jim | Bob |
Bill | Mark |
Jane | Jim |
Bill | Shane |
Jim | Bill |
<tbody>
</tbody>
In the above example, only the bottom row of cells should be highlighted as they are the 3rd instance of "Jim" and the 3rd instance of "Bill". I want the first two of any string to not be highlighted.
Is there some way to do a rolling "Count" conditional formatting that will check cells sequentially from top left to bottom right in a given range?