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...