Duplicate value formula to be used in conditional formatting

[Keibri]

Hi guys,

if it is not too much of an inconvenience was wondering whether someone can assist me with the above.

Basically I have a date set consisting of 6 columns. I would like to insert a conditional formatting based on the first 3 columns.

If data is repeated in the first 3 columns, it would highlight the whole row. What is important, is that the row will be highlighted only if the information is repeated in all the first 3 columns

For ease of reference I am attaching a test file.

Would really appreciate your kind help.

Thanks

Keibri

[Fluff13]

How about
=COUNTIFS($C$7:$C$17,$C7,$D$7:$D$17,$D7,$E$7:$E$17,$E7)>1

[avk]

In "I7" =C7&D7&E7 copy paste down.
& then using CF function. in "I" column

[Keibri]

Hi guys, tried both solutions and both worked great.

Much appreciated

[Fluff13]

You're welcome & thanks for the feedback.