I have a drop-down box on A2 and it has a range of numbers from 1-6
if i select 2 in the drop-down box, it will hightlight the box in yellow.
but there's one problem and that is previously i select 3 and type a date on A5 but now i select 2 and cell A5 doesnt clear the content in it.
that means i need to clear those that is not highlighted in yellow.
i have set the box to be highlighted in yellow according to the drop-down box number.
can i know how to clear the content inside the cell which is not highlighted in yellow?