Hi guys & gals,

On one sheet I have a list of shops (1 column) & the products they sell (other column):

grocer | fruit
grocer | vegetables
record store | CD
record store | records

On another sheet I "constructed" the ground plan of the mall, and I put a list-box from which the customer can choose the product. By doing this, the name of the stores (some products are sold in different shops) should change colour.

So far I have the initial list, and through some VB I can extract the correct info to a different table.

The problem now is: I need a formula to use in the conditional formatting to change the colour of the "selected" stores...

Is this clear enough? Thanks for any feedback!