Report

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

Ask a question ritzutak 2Posts Tuesday September 1, 2015Registration date September 2, 2015 Last seen - Last answered on Nov 24, 2016 at 06:18 PM by Ambucias
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 
Helpful
+3
plus moins
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
Was this answer helpful?  
ritzutak 2Posts 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.
Helpful
+1
plus moins
Thanks for the feedback.

I feel happy to help you.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
BormannPL 1Posts 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?
Reply
Ambucias 42439Posts Monday February 1, 2010Registration date ModeratorStatus June 28, 2017 Last seen - Nov 24, 2016 at 06:18 PM
Hi

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

Cheers
Reply

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!