How to compare two columns in Excel and highlight matching cells?

N

N

Newbie Ivanovich2021-11-25 05:42:17

excel

Newbie Ivanovich, 2021-11-25 05:42:17

How to compare two columns in Excel and highlight matching cells?

There is a column in sheet 2 containing values that need to be compared with the values in the cells of column 2 of sheet 1 and highlight matching cells.
How to do it?

PS
Excel almost never use a complete noob in this matter)

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Karabanov, 2021-11-25
@karabanov

How to Compare Two Columns in Excel

Similar questions

N

Nikolai Shevtsov2015-05-27 18:07:17

How to defeat host mismatch with HP MSA1500 drive? 2Reply

K

KTG2021-12-15 05:23:05

How to do a string search of all empty cells and return an array of column numbers (formula)? 2Reply

P

P_Zeger2014-03-26 22:15:00

How to upload Excel file in MS Server Management Studio 2012? 1Reply

S

sv82016-05-23 20:37:36

How to format date with maatwebsite/excel in Laravel? 2Reply

A

Arsen Asatryan2020-09-04 13:39:33

How to number duplicates? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question