Change cell color based on another column
Solved/Closed
ritzutak
Posts
2
Registration date
Tuesday September 1, 2015
Status
Member
Last seen
September 2, 2015
-
Sep 1, 2015 at 08:24 AM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - Nov 24, 2016 at 06:18 PM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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!
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!
Related:
- Change cell color based on another column
- Notepad++ change background color - Guide
- Change computer name cmd - Guide
- How to change free fire google account to another google account - Guide
- Change lg tv name - Guide
- Sound card color code - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 1, 2015 at 09:13 AM
Sep 1, 2015 at 09:13 AM
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
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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 2, 2015 at 09:36 AM
Sep 2, 2015 at 09:36 AM
Thanks for the feedback.
I feel happy to help you.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
I feel happy to help you.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
BormannPL
Posts
1
Registration date
Thursday November 24, 2016
Status
Member
Last seen
November 24, 2016
Nov 24, 2016 at 05:01 PM
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
Posts
47310
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
February 15, 2023
11,166
>
BormannPL
Posts
1
Registration date
Thursday November 24, 2016
Status
Member
Last seen
November 24, 2016
Nov 24, 2016 at 06:18 PM
Nov 24, 2016 at 06:18 PM
Hi
The solution was deleted by mistake, it has now been restored.
Cheers
The solution was deleted by mistake, it has now been restored.
Cheers
Sep 2, 2015 at 01:18 AM
Thanks a lot for your help, it was very useful for me. my problem is now solved.