Change cell color based on another column [Solved/Closed]
Posts Tuesday September 1, 2015Registration date
September 2, 2015
Sep 1, 2015 at 08:24 AM - Latest reply: Ambucias51075
Posts Monday February 1, 2010Registration dateModeratorStatus
April 20, 2018
- Nov 24, 2016 at 06:18 PM
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!