Change cell color based on another column Solved/Closed

Question

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!

Mazzaropi · Answer

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

Mazzaropi · Answer

Thanks for the feedback.

I feel happy to help you.

Have a nice day! 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Change cell color based on another column

2 responses

Similar discussions

Subscribe To Our Newsletter!