MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Custom Cell formatting


Posted by andrew miller on October 12, 2001 4:23 AM

I have cells that look to cells on another spreadsheet for their value. If the cell that these are looking to is blank, the ones looking automatically put a zero for their value. I don't want that. I want them to remain blank if the cell they are lookin to is blank. I can make this happen using an "if" function but I thought it might be easier if I could create a custom cell format that would automatically make them blank instead of showing a zero. Does anyone know if this can be done, and if so, what formula you would use?


Posted by Robb on October 12, 2001 4:31 AM

Andrew

Go to Tools/Options
Select the View tab
in the section "Window Options, uncheck "Zero Values"

Zero values should now be suppressed.

Any help?

Regards

Posted by andrew miller on October 12, 2001 4:37 AM

Exactly what I needed. Thanks.

: I have cells that look to cells on another spreadsheet for their value. If the cell that these are looking to is blank, the ones looking automatically put a zero for their value. I don't want that. I want them to remain blank if the cell they are lookin to is blank. I can make this happen using an "if" function but I thought it might be easier if I could create a custom cell format that would automatically make them blank instead of showing a zero. Does anyone know if this can be done, and if so, what formula you would use?