|Posted: May 8, 2016, 11:28 am - IP Logged|
The sheet contains one macro, so you will have "enable macros" when you open it.
The static data in column N are the numbers 0 - 9 with unique background colors.
The data in column O is a count of how many times a number appears in the range entered in Cell A2.
The range entered in Cell A2 should be of the single digits in columns D through J you want ot color.
Click the button to execute the macro which will color the cells in the range entered in Cell A2 to the background colors of the matching digits in column N.
The cells in columns D through J breakout each digit from the data you already have in columns B and C.
Change the range in Cell A2 to color more or less cells. Change the background color of the numbers in column N to whatever color you want and then click the button.