[RESOLVED] set value of cell to 0 based on value of another cell in a TABLE range

[scoobster]

Hi

I have a TABLE range which has 3 columns. Column 1 is called 'Product', Column 2 is called 'Price' and column 3 is called 'Discount'.

I only want a value in one of these cells for each product so basically a user cannot have both a price and discount.

I need some code that will set the discount value to 0 on the same row if the user has entered a price value. Same if the user has entered a value in the discount column - I want the price on the same row to be set to 0.

I am thinking of using the Worksheet_Change event for this so that the update happens immediately.

Thanks for any suggestions on how to best go about this.