Hi,

Do you want the text or numbers to reappear when column A doesn't equal N/A?

If so highlight the cells click on your Home tab, then click on your
conditional formatting in the styles section, go to new rule, then Use a
formula to determine which cells to format, Type in =A1="N/A" then format
your text to turn white.
--
Regards
Warren


"slavenp" wrote:

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!