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

ritzutak 2 Posts Tuesday September 1, 2015Registration date September 2, 2015 Last seen - Sep 1, 2015 at 08:24 AM - Latest reply: Ambucias 53244 Posts Monday February 1, 2010Registration dateModeratorStatus July 18, 2018 Last seen
- Nov 24, 2016 at 06:18 PM
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!
See more 

5 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Sep 1, 2015 at 09:13 AM
1
Thank you
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1682 users this month

ritzutak 2 Posts Tuesday September 1, 2015Registration date September 2, 2015 Last seen - Sep 2, 2015 at 01:18 AM
A very good morning Mazzaropi .
Thanks a lot for your help, it was very useful for me. my problem is now solved.
Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Sep 2, 2015 at 09:36 AM
1
Thank you
Thanks for the feedback.

I feel happy to help you.

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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1682 users this month

BormannPL 1 Posts Thursday November 24, 2016Registration date November 24, 2016 Last seen - Nov 24, 2016 at 05:01 PM
I am new here so my question can seem funny but... where can I see the solution?
Ambucias 53244 Posts Monday February 1, 2010Registration dateModeratorStatus July 18, 2018 Last seen > BormannPL 1 Posts Thursday November 24, 2016Registration date November 24, 2016 Last seen - Nov 24, 2016 at 06:18 PM
Hi

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

Cheers