Dear Members,

i need your help to solve the problem i am facing and can't find a solution for it.

the problem is that i have 2 sheets in one file; one of them containing a list of IDs and descriptions for products and each product line has specific color based on specific coloring code, the other sheet contains the same list of IDs and description but without coloring and it have different format, i want to look up the ID in the Colored sheet and copy its color to the same ID in the non-colored sheet with an automatic way allowing me when i make any changes in the colored sheet it reflects automatically in the non-colored sheet with the modified color

i hope i made it clear as possible as i could; looking forward to your help ASAP

Thanks all