Fill other columns
 

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!

Fill other columns
 

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!

Fill other columns
 

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!

Fill other columns
 

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!