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

D

del9937882016-09-30 12:54:24

How to output from excel to phpmyadmin database? 2Reply

P

partyzanx2019-03-08 03:49:21

How to make a selection of passengers in excel by parameter? 2Reply

P

partyzanx2019-03-08 20:01:40

How to count the number of filled rows in EXCEL according to a criterion? 1Reply

P

partyzanx2019-03-11 14:52:24

How to hide multiple rows in excel if their cells are either empty or =""? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question