# Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.