Hello all,
I am aware there could already be some literature on this one; however, I could not really find a solution on some of the threads I found...
So I have a spreadsheet and I would like cells within a column to highlight if the same value is repeated 3 or more times; I believe this to be achieved via Conditional Formatting and I have tried this, and this.
None of it works, the best I have managed is to get the first cell highlighted... I would like all cells in column A that have the same value repeated 3 times or more to be highlighted.
Here's the formula I am using:
What I am doing wrong? I am using Excel 365.
Many thanks in advance!
I am aware there could already be some literature on this one; however, I could not really find a solution on some of the threads I found...
So I have a spreadsheet and I would like cells within a column to highlight if the same value is repeated 3 or more times; I believe this to be achieved via Conditional Formatting and I have tried this, and this.
None of it works, the best I have managed is to get the first cell highlighted... I would like all cells in column A that have the same value repeated 3 times or more to be highlighted.
Here's the formula I am using:
Excel Formula:
=COUNTIF($A$3:$A$500, $A3) >= 3
What I am doing wrong? I am using Excel 365.
Many thanks in advance!