I have two data validation drop down boxes that are linked. 1. Select brand.
2. Select Colour . The colour options list (box 2) is different depending on
which brand is selected.
It works great when starting from a blank sheet, but after making a
selection in both 1 and 2, if you go back and select a different brand in box
1, it will still display the colours from the prevoius brand selection in box
2 and result in an error in the total column.
Is there any way I can get box 2 to clear when a new selection is made in
box 1?

Thanks for your help.