Need to highlight entire rows when duplicate values found in two separate columns

I'm woring with another colleague on analysing a data worksheet that has over 35,000 rows and 20 columns A-T. We need to highlight contiguous rows that contain duplicate values that exist in both ColD, AND ColJ, regardless of how many duplicates they could be.
For example:
ColD - - - - - - - ColJ
Oragne - - - - - Sugar
Orange - - - - - Sugar
Orange - - - - - Sugar
These three contiguous rows should be highlighted in yellow because duplicates found in BOTH columns. They could be any number of contiguous rows 2-n, they are three in this example.

Orange - - - - - Sugar
Banana - - - - - Sugar
Cannot highlight any of these rows despite having duplicates in one column only which is ColJ in this example, regardless of how many duplicates may exist in that column.

Can we get some precious help with this request please?

Much appreciated.

T.

Originally Posted by AlphaFrog

Select rows 2 to the last used row and enter this Conditional Formatting formula

Formula:

Please Login or Register  to view this content.

Thank you very much AlphaFrog for that genius formula. I feel "rich" now to have such an amazing solution besides PCI's code. It did as exactly as needed.
More than grateful.

T.

Thank you very much PCI for such magic code which did as exactly as needed. You have such a valuable addition to this world.
Merci beaucoup, plus que reconnaissant.

T.