Conditional Formatting on a row based on values in multiple cells

[EWolfe]

Hello,
I would like to apply conditional formatting to entire rows based on if conditions of the following are met.

Column A = First Name
Column B = Last Name
Column C = Destination
Column D = Departure Date
Column E = Return Date

I would like the entire row to be yellow if the data in columns A, B, D & E = the data in columns A, B, D & E in another row. (i.e. duplicate data). I don't want to remove the duplicates, only highlight them.

I have attached an example document.

[TMS]

Try, untested, CF formula:

Please Login or Register  to view this content.

[TMS]

Thanks for the rep.