Conditional Formatting

[cdnqte]

I have a sheet that has multiple lines of data and in many cases there are repeated lines because I am linking headers and lines.

For example:

A B C D E F
Contract Customer Name Contract Date Charge qty Price
RC10111 Jim Smith Contract 01/01/16 FRT 1 50.00
RC10111 Jim Smith Contract 01/01/16 SUB 1 150.00
RC10111 Jim Smith Contract 01/01/16 PRT 1 35.00
RC10980 Pow Wow Contract 12/15/16 SUB 1 350.00
RC10350 Hot Rod Contract 03/01/16 DEL 1 800.00
RC10350 Hot Rod Contract 03/01/16 SUB 1 300.00

I want to conditional format it so that for the rows with duplicate data in A-C the font is white - only the first row should be in the default font for columns a-c then the rest would be white but d-f would remain in the default text

Any help/suggestions would be greatly appreciated!!!

 

[AliGW]

Just copy this row to 7th row and see if it works

RC10111 Jim Smith Contract 01/01/16 PRT 1 35.00

That would need to be visible as it is a new instance of the ID.

 

[ArnoldMS]

Hello, have you tried this one?
=AND(COUNTIF($A$4:A4,A4)>1,COUNTIF($B$4:B4,B4)>1,COUNTIF($C$4:C4,C4))