I have a table that list 160 paint colors with their own id number 1-150.
6 Supplers for those colors.
Each supplier cell background is color coded.
When I eneter a paint number in the worksheet I want the cell's background to change and match the correct suppiler.
Column = 1-50 colors
Column 2 - each of those colors has the corresponding supplier adjacent to their respective colors.
Is it possible that when a color number is entered into the cell that you can have it find the correct supplier in column 2 and change the background color of the input cell to match?
6 Supplers for those colors.
Each supplier cell background is color coded.
When I eneter a paint number in the worksheet I want the cell's background to change and match the correct suppiler.
Column = 1-50 colors
Column 2 - each of those colors has the corresponding supplier adjacent to their respective colors.
Is it possible that when a color number is entered into the cell that you can have it find the correct supplier in column 2 and change the background color of the input cell to match?