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?