Looking to create conditional formatting using a reference column.

[gsfortis]

I have two large tables with nearly the exact information-- one is an [OriginalTable], and another is being edited [EditedTable]. It's some 5,000+ records a dozen+ columns. It's basically a list of locations (Name, Region, District, Street Address, etc...)

I want to create some conditional formatting to highlight when the values don't match. Normally I might do something along the lines of =[EditedTable]B2<>[OriginalTable]B2, but the edited table might be resorted, filtered.. and then that won't work.

Instead, I want to use a unique identifier in Column A of both tables as a reference.

So, using Column A, if a Name value is changed, or Region or District in [EditedTable]... how can I apply colored conditional formatting to I cross-reference against the [OriginalTable] and highlight a changed value?

Many thanks!

 

[6StringJazzer]

Since you were not specific about where your data is located I am going to have to give you a generic answer. I will assume your data is on two different sheets called OriginalTable and EditedTable. I am going to further assume that these tables are in columns A:G.

You do not say which table you want to highlight, so I will assumed EditedTable.

Highlight columns B:G in EditedTable and use this CF rule "Use a formula..."

=B1<>VLOOKUP($A1,OriginalTable!$A:$G,COLUMN(B1),False)