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

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

Workflow

Accepted answers

Ohh, I got you!

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

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

Best

Alex

I need to compare column values

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:

Thank you!

Hi Can you please share the entire flow working on same scenario. Thankyou