Comparing data in rows in multiple columns?

Hi all,
I am working on a project where I’m trying to identify similar assets that can be destroyed or digitised. I am basically trying to compare the date in rows within the same column and then do the same for multiple columns. If all match then highlight the rows.

Please see below a sample example of my data(please see attached)

I’m trying to work on a formula that would do the following :

It title column B in a row is the same
Is Ep# I column L n a row is same
If medium column D in a row is same
If element type column f in a row is same
If version column G in a row is same
If standard column I in a row is same
If AR/ audio Config column H is same
Then colour rows yellow

Or if all cells in rows in the following columns B, L, D, F, G, I, H match than colour yellow.

And then
If colour of row is yellow and Size format column E contains text “DAT”, place text “Destroy” in Recommendation Column T.

Any help or ideas would be very much appreciated. Thank you in advance.