Hi

I want to highlight only the cells that have the same name repeated more than 5 times between 2 columns.

The formula below works except when entering formula into conditional formatter in excel it highlights all the cells from D4:E10 which contains other names.

=SUMPRODUCT((D4:E10="Billy")*(D4:E10>5))

cam.PNG

Basically If Billy is repeated more than 5 times I want to highlight all Cells containing Billy within cells D4:E10.

I appreciate any help on this