Conditional format with reference data

[Harold Garcia]

Good Day Excel Experts,

Can you help me to conditional format a given table;

Name	Site 1	Site 2	Site 3	Site 4
Customer 1	100
Customer 2	300			100
Customer 3			400
Customer 4		150	200	300
Customer 5	1050
Customer 6	100	500	450	600

<tbody>
</tbody>

I need a formula that will highlight the Customer's column with more than one(1) data in a row.

Thank You

 

[sheetspread]

=counta(offset(a2,,,,5))>=3

 

[sheetspread]

for columns:

=COUNTA(B:B)>2