Compare 2 Columns

[Djchaney3]

Situation:

I have an Excel Spreadsheet with data pulled from 2 different access databases. One column contains a Point of Sales Customer Number(PosCustomer) pulled from the Point of Sales Database, another contains the Customer Information Service Customer Number(CisCustomer) and the last one contains the Customer Information Service Account Number(CisAccount) both pulled from Customer Information Service Database

Goal:

If PosCustomer = CisCustomer then highlight Red
If PosCustomer = CisAccount then highlight Blue

Question:

How would I do this?

[NBVC]

Use conditional formatting.

Assuming PosCustomer is in column A, CisCustomer is in column B, CisAccount is in column C:

Select full range in column A and go to Format|Conditional Formatting

Select Formula Is from 1st drop down and enter formula: =Countif(B:B,A1)
where A1 is the top most cell in your selected range.

Click Format and select red from the Pattern tab.

Click Ok and then click Add

Select formula is again and enter formula: =Countif(C:C,A1).
where A1 is the top most cell in your selected range.

Click Format and select blue from the Pattern tab.

Click Ok. Click Ok again.

[Djchaney3]

Thanks a ton, I was trying to do it in VBA but this is much simpler

[NBVC]

You're welcome!