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

How about using a helper column and concatenate column B with I and then format the helper column.

Example, I used column J as the helper column...

Conditional Formatting

• Highlight applicable range >> J2:J20
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =COUNTIF($J$2:$J$20,J2)>1
• Format… [Number, Font, Border, Fill]
• OK >> OK

If this does not do it for you, then how about a sample workbook with a before and after.

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?

Without seeing your exact data, let me know if this helps...

You are very welcome and thanks for the feedback