**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hi, I would like to highlight a cell if another one is highlighted. The other one is highlighted if in the same column there is a duplicate value.
Thanks

Solved by O. B. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
31/05/2018 - 03:12

Hi!

User
31/05/2018 - 03:12

I would like to highlight a cell if another one is highlighted. The other one is highlighted if in the same column there is a duplicate value. Thanks

User
31/05/2018 - 03:12

Can you please help me to find the solution?

Excelchat Expert
31/05/2018 - 03:12

Ok

Excelchat Expert
31/05/2018 - 03:13

Can you provide a sample of data for applying

User
31/05/2018 - 03:14

Here you go :)

Excelchat Expert
31/05/2018 - 03:15

Ok the cells at B2 throw B6 is duplicated

Excelchat Expert
31/05/2018 - 03:15

So you want to highlight the cells A2 to A6 ???

User
31/05/2018 - 03:15

Yes exactly and I would like to highlight the cell in A2, A3, etc.. if the cell in B2, B3, etc is highlighted

Excelchat Expert
31/05/2018 - 03:16

Ok

Excelchat Expert
31/05/2018 - 03:16

let me make something

User
31/05/2018 - 03:16

ok thanks

Excelchat Expert
31/05/2018 - 03:17

That is the formula

Excelchat Expert
31/05/2018 - 03:18

With conditional format I use this formula =COUNTIFS($B:$B,B1)>1

Excelchat Expert
31/05/2018 - 03:18

At column A

Excelchat Expert
31/05/2018 - 03:19

Hello

User
31/05/2018 - 03:19

Ok awesome thanks

User
31/05/2018 - 03:20

Do I need to create the formula for each cell in A?

Excelchat Expert
31/05/2018 - 03:22

nO

Excelchat Expert
31/05/2018 - 03:23

select all the column A and then conditional format with formula

Excelchat Expert
31/05/2018 - 03:23

And use the formula

Excelchat Expert
31/05/2018 - 03:23

EV849725761CN

Excelchat Expert
31/05/2018 - 03:23

Sorry

Excelchat Expert
31/05/2018 - 03:23

This =COUNTIFS($B:$B,B1)>1

User
31/05/2018 - 03:24

Only the first cell is highlighted for me

Excelchat Expert
31/05/2018 - 03:26

select all the column before you use the conditional format

Excelchat Expert
31/05/2018 - 03:26

Or use the match properties tool

User
31/05/2018 - 03:27

Ok perfect it worked!

User
31/05/2018 - 03:27

what is the match properties tool

Excelchat Expert
31/05/2018 - 03:27

the tool that copy the format from one cell to another

User
31/05/2018 - 03:28

OK where can I use it

Excelchat Expert
31/05/2018 - 03:30

If it work you don't need to use it

User
31/05/2018 - 03:30

Ok cool

User
31/05/2018 - 03:30

Thanks for your help

Excelchat Expert
31/05/2018 - 03:30

You can use it when you want to format sells like other cells

Excelchat Expert
31/05/2018 - 03:31

So it copy the formats

Excelchat Expert
31/05/2018 - 03:31

anything else

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*