How to make a cell invisiable without deleting the formula.

**NBVC** · 06-04-2007, 03:53 PM

Try this in C2 copied down and across:

=IF(INDIRECT("Day"&COLUMN(A1)&"!C"&ROW(A2))=0,"",INDIRECT("Day"&COLUMN(A1)&"!C"&ROW(A2)))

**Cellar Webs** · 06-04-2007, 04:41 PM

NBVC,
Thanks for the help! It works great.
Cellar Webs

**Cellar Webs** · 06-05-2007, 04:02 PM

NBVC,

Is there some way to have the cells become invisible if they equal zero on "Day1"? Maybe I have to use a macro. I don't know. I want the computer to erase all the zeros without erasing the format of the cells. Your code worked great for what I wanted to do before, thanks.

Cellar Webs

**NBVC** · 06-05-2007, 04:36 PM

There are a few ways.

1. You can update your formulas in Day1 to be part of an If() statement such as the one I gave you before....e.g. =IF(your_formula=0,"",your_formula) where your_formula is your current formula residing in the cells.

2. A more global way is to go to Tools|Options and in the View tab uncheck the "zero values" checkbox.

3. With Conditional Formatting. Select the entire range. Go to Format|Conditional Formatting and select Cell Value Is >> equal to >> =0
Then click Format and from the Font tab, select White from the colour pallet to match your sheet background. Click Ok. Click Ok again.

4. Select cells go to Format|Cells and select Custom from the Number tab. Enter: 0;-0; as type

**marcus23x** · 06-05-2007, 04:39 PM

hi, I have the same question, but with a different formula. All I want to do is to add all my cells in the same row together, but if the total is zero I want it to show nothing.

Something basic as =SUM(A1:A10)

Thank you in advance !

**NBVC** · 06-05-2007, 04:41 PM

Originally Posted by marcus23x

hi, I have the same question, but with a different formula. All I want to do is to add all my cells in the same row together, but if the total is zero I want it to show nothing.

Something basic as =SUM(A1:A10)

Thank you in advance !

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))