Forum Discussion

Copper Contributor

Nov 01, 2020

Need to select unique cells from 2 worksheets with identical column names and highlight differences

Hi: I have 2 identical worksheets that will be used as a data entry worksheet and the second will also be used as a data entry worksheet by a second person entering the same data as a double check f...

excel

office 365

Riny_van_Eekelen

Platinum Contributor

Nov 02, 2020

RickZler A CF-rule in Sheet1 like =A1<>Sheet2!A1 applied to the entire data range, for example $A$1:$M$2500 , should allow you to highlight differences between the two sheets for every single cell in the applied range. However, Excel can not tell which entries are correct and which are not. Therefore, highlighting incorrect entries by the second person makes no sense, as the same cells will show up as "not equal". You'll need a third person to judge who entered the data correctly.

RickZler

Copper Contributor

Nov 02, 2020

Riny_van_Eekelen

Hi:

Thanks for the reply and understand the error showing on compliancy rules. I'll try this solution but I seem to recall this will not propagate to newly entered records unless I add a bunch of blank records to each of the comparison spreadsheets and apply the formatting to those blanks. Is this correct? So it wont actually apply to new entries into the spreadsheet only roes that already have it applied in the formatting rules for those cells ?

Thanks