Delete/Hide data depending on cell value...

[wardga]

Hi all

hopefully this is easy.

I have a sheet where in cell B2 I have a drop-down list with the options "Yes" and "No".

If "No" is selected, I would like data to disappear from column F, cells 12 thru 20.

I thought I could do this by simply using conditional formatting to just turn the text colour white - thus it "disappearing". I can't seem to get this to work though.

In conditional formatting I'm currently setting it to Formula Is =IF(B2,"No")

I know this is wrong - but is what I want possible? If not, any other ideas?

cheers

[NBVC]

The formula for all the cells in those rows should be:

=$B$2="No"