Conditional Formatting to find duplicates from 3 columns and highlight entire row.

[bobjet]

Hi Everyone, I am stuck at this point and would like to find a solution please. I have a set of data about 5,000 customers names that buy parts. In this data, i have 3 columns that i specifically want to find if there are duplicates. In columns D , F and G are the only columns that i want to find an exact match and if possible to highlight the entire row when found. I need to find a solution using conditional formatting that updates every time a customers name is entered.
Your help is much appreciated.

[JohnTopley]

Select range A2:F100 (or how many rows you require)

in CF

Use formula ..

=COUNTIFS($D:$D,$D2,$F:$F,$F2,$G:$G,$G2)>1

Select FILL colour==>OK

[bobjet]

Hi John, it worked perfectly . I have one more question if you don't mind. If in future i wanted to adjust this formula to look for only duplicates in the same columns ,D, F and G, that match "Credit" , would this change the formula too much ?
Thanks again .

[JohnTopley]

Try

=COUNTIFS($D:$D,$D2,$F:$F,"Credit",$G:$G,$G2)>1

[bobjet]

Hi John,
Thank you so much. Your help is appreciated.