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