I would like to set up a s/sheet so if I enter 'not applicable' in the first
column the remainder columns get blanked out, either with a block of colour
or 'not applicable'. Either would be helpful.

I am using Office 2007.

Hope you can help!