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:

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

If title column B in a row is the same
If 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.

inso said:

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.

Click to expand...

You are unclear. You should have set up an attachment and an example of how looks the expected result in a few examples.
This is my understanding of your problem (see attach)
You need a Conditional Formatting for color rows

Here missing formula for multiple conditions (unclear request).
Given that, the formula can not count the cells with color that created with a Conditional Formatting, I think you're going to have to solve using VBA.

Excel 2010
With CountIfs()
http://www.mediafire.com/view/qa0dq94ouvdb8bq/08_19_15.xlsx

Thank you so very much for your help.
And thank you for pointing out I have not included and attachment with similar entries in the sample data. Apologies as was unclear in my criteria as well. What I need to do is compare the data within the rolls in columns B, L, D, F, G, I, H and mark them as duplicate instead of Destroy. So the two rows highlighted in blue should be the ones that come up as Duplicate. And only then as a second rule if Colum E contains certain text such as DAT it is Marked as Destroy. Hope this makes sense. I’ve attached an example of how it should look like once applied.
Thank you again for all your help., it is very much appreciated.

Hi,

Try the following formula in T2:

=IF(COUNTIFS($B$1:B2,B2,$L$1:L2,L2,$D$12,D2,$F$1:F2,F2,$G$1:G2,G2,$I$1:I2,I2,$H$1:H2,H2)>1,IF(E2="DAT","Destroy","Duplicate"),"")

Drag this downwards.

inso said:

I’ve attached an example of how it should look like once applied.

Click to expand...

I will try to modify the formula created by @cbatrody
It might help you