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!

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!

Cheers for the quick response. What you supplied kind of works as it blocks
out one cell after the cell that has 'n/a' in it. I would like to block out
10 cells on the same row after I enter 'n/a'. Is this possible?

Again, thanks for help.

"Warren Easton" wrote:

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!

Sorry Highlight the cells and put in the same formula but the part I forgot
was to put a $ sign before A1 like =$A1="N/A"
--
Regards
Warren


"slavenp" wrote:

Cheers for the quick response. What you supplied kind of works as it blocks
out one cell after the cell that has 'n/a' in it. I would like to block out
10 cells on the same row after I enter 'n/a'. Is this possible?

Again, thanks for help.

"Warren Easton" wrote:

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!