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?
