easy formula help

[silverskye787]

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?

 

[ravishankar]

Hi
range("A4:A5").clearcontents
range('A4:A5").interior.colorindex = x1None
Change the range to suit your number in the dropdown
RAvi

 

[silverskye787]

thanks alot.. but i only want to delete those contents that are not highlighted in yellow but keep those that are highlighted in yellow..

as in not clear the whole content

 

[ravishankar]

HI
clear cotent works on the range you specify. I have given a hypothetical example fo A4:A5. You should modify it to suit your needs (where yellow is /is not there)
ravi