Compare columns in 2 sheets and highlight using color if there is a mismatch

[rachana19]

Hi All,

I am working on a use case where I need to compare two sheets (Column names are different) in an excel.

If there is a mismatch found in columns, I need to highlight in red color, if no mismatch then highlight in green color.

Please suggest which tool combination will be best for this.

Thanks 

[grossal]

Hi @rachana19,

do you want to compare the column names or the column values?

Best

Alex

[rachana19]

I need to compare column values

[grossal]

I would suggest the following:

- 2 Input Tools

- 2x Record ID

- Join 

- Basic Table with Create Row Rule for highlighting

[rachana19]

Thanks a lot for reply.

So till now I was able to below -

- 2 Input Tools

- 2x Record ID

- Join 

- Formula tool (added new column with value True or False if there is a mismatch)

However, while using Basic table, I need to color only that cell where there is a mismatch. So I used column rules and can color new column created in formula tool by checking value True False. How can I color the actual value here?

[grossal]

Here is a minimal example.

Input: 

A	B
1	2
2	2
2	3

 

Result:  

 

[rachana19]

Thanks a lot for this. Appreciate your response. 

Is there any way to highlight only that cell?

As I can have series of columns in both sheets say A1 to match with B1, A2 to match with B2, A3 to match with B3.

If A1 = B1, A2 != B2, A3=B3, I only need to highlight A2 and B2

If I highlight the whole row, it will be incorrect

[grossal · Accepted solution]

Ohh, I got you!

It's a bit confusing, but you can create a Column Rule with my Row Rule Formula.

[rachana19]

Thanks a lot for the suggestions. It worked fine.

Appreciate our help.

[Teresa3]

Hi, is there an option to do the same when the data is among each other? I tried something like [Row]!=[Row+1], but this is not possible.

like: 

value1	value2	FileName
A	B	File1
A	C	File2
sdfkjhdfk	K	File1
dsfasdfdsf	K	File2

Thank you!