Please can anyone help me with a micro that highlights rows in a range whereby most of the columns (i.e 5 of 8 columns ) or the entire row contains a duplicate entries for every column. See rows 1 & 2 of the example data below. Row 3 shouldn't be highlighted.

Example data:
A B C D E F G H
1 N/A N/A N/A N/A N/A N/A N/A N/A
2 NK NK NK NK NK NK NK NK
3 N/A N/A cif n/a cif dell Rbd Sbc

I really appreciate any help you can provide,

Mo