Triplicate values need highlighted

[congresses]

BOB BILLY JOE JOHN
h12 h17 h19 h19
h13 h18 h20 h18
h21 h19 h51 h13
h14 h22 h70 h90

So what i need done is to highlight all DUPLICATE values one color and all TRIPLICATES or GREATER values highlight a different color. The problem I've been running into is the criteria range as i am only able to check one criteria example of where I am stuck =COUNTIF($A$2:$D$99,$D$4)=$G$5
this example allows me to type in 3 and it will tell me true or false on wether my criteria ($D$4) has 3 of the same values, but i need to scan for the entire spreadsheet. meaning i need the criteria to be $A$1, $A$2 , $B$1, $B$2 , etc etc etc....

[Teethless mama]

CF:

=COUNTIF($A$2:$D$5,A2)>2 Top

=COUNTIF($A$2:$D$5,A2)=2 Bottom

[congresses]

ty for responding, does this only the criteria in A2 though ? i need it to scan for all entries that have been put in the excel three times not just 1 cell

[Teethless mama]

ty for responding, does this only the criteria in A2 though ? i need it to scan for all entries that have been put in the excel three times not just 1 cell

First highlight all entries, then use my formula in post #2

[congresses]

I don't understand top and bottom on cf could you clarify a little more

[Teethless mama]

See the attached

[congresses]

worked like a charm thank you so much!!

[congresses]

next question some cells end up with a space at the end of their value and it is throwing excel off from catching the duplicates how do i ignore the spaces at the end of a value in a cell?

[Tony Valko]

Remove the spaces.

The macro at this website will remove all leading/trailing
and multiple interspersed char 32 space characters.
It will also remove and/or convert char 160 non breaking
spaces into standard char 32 space characters. It will
work on text or numbers and the numbers will be
converted to true numeric numbers.

I use this macro dozens of times every single day!
It's a real time saver.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall