Compare 2 columns for duplicates within the columns and against the 2 columns

Is it possible to show what you mean with a little more detail so I can copy what you did and apply it to my sheet as I am not following you 100%. I am using excel for mac 2011..

You want me to create a new column.. combine the data together from columns B and I then apply your formula to this new column?

I just need Column B and I not all the columns in between... and then how do I apply the format formula to your formula?