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.