Search results

Hui - This is exactly what I was trying to accomplish. I have tried with conditional formatting but my method kept coming up short. Thank you folks for helping an old man out.

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