Change cell color based on another column [Solved/Closed]

Report
Posts
2
Registration date
Tuesday September 1, 2015
Status
Member
Last seen
September 2, 2015
-
Ambucias
Posts
51375
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
December 12, 2019
-
Hi All,

I am not very good at excel, however I am looking for a solution for the following problem.

There are two columns (Column A and Column B) in excel and both the column have some numbers. Now if any number of column A matches with the number in column B then the number in Column B will automatically be highlighted in some color.

Say Column A has 100, 200, 300, 400 and Column B has 100, 140, 500, 200. Then the cells containing 100 and 200 in Column B will be colored. Now if in Column A, I add 500, then automatically the cell containing 500 in Column B will be highlighted.

I am using Excel 2013.
Your answers will be of great help!

6 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
ritzutak, Good morning.

I did an small example for you:
http://speedy.sh/R67bH/01-09-2015-en-Kioskea-Conditional-Format-OK.xlsx

Select column B1:B10
Conditional Format Menu
Using formula
=ISNUMBER(MATCH(B1,$A$1:$A$10,0))

Format fill colour as you desire.
OK.

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5807 users have said thank you to us this month

ritzutak
Posts
2
Registration date
Tuesday September 1, 2015
Status
Member
Last seen
September 2, 2015

A very good morning Mazzaropi .
Thanks a lot for your help, it was very useful for me. my problem is now solved.
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
Thanks for the feedback.

I feel happy to help you.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5807 users have said thank you to us this month

BormannPL
Posts
1
Registration date
Thursday November 24, 2016
Status
Member
Last seen
November 24, 2016

I am new here so my question can seem funny but... where can I see the solution?
Ambucias
Posts
51375
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
December 12, 2019
13513 > BormannPL
Posts
1
Registration date
Thursday November 24, 2016
Status
Member
Last seen
November 24, 2016

Hi

The solution was deleted by mistake, it has now been restored.

Cheers