I want to highlight triplicates values in my whole excel table
However it is not working with what I tried :
=COUNTIF($B$3:$H$24,$B$3:$H$24)>=3
I know that this formula is incorrect, it says: count every $B$3:$H$24
in the whole range: $B$3:$H$24
.. this doesn't mean anything...
What I want is the exact same function as the native excel option : "Highlight duplicate" which can apply to a whole table.
I applied this formula to the "highlight" functionality of excel which itself applies to table range which is $B$3:$H$24
This would be an exemple of an expected result: