Eli
Use generic terminology as much as possible. Specifically, what are you
doing when you are "reporting it in the other worksheet (Used_prod)"? HTH
Otto
"???" wrote in message
...
Hi,

I have in one workbook 2 worksheets that one of them (Prod_list) is the
list
of products and in the second worksheet (Used_prod) i need to report if
the
product was used.
I am wondering if it is possible to color the range of the specific
product
in the products list (Prod_list) while i am reporting it in the other
worksheet (Used_prod)?

Thanks in advance for your time

Eli