Is it possible to tell Excel NOT to display #VALUE! in a cell that has a formula in it?
I have a sheet which is locked, all bar a couple of columns for input. The cells in the locked columns display this all the way down to the last cell when waiting for an answer to be displayed, but it is hellishly ugly to see it like this. Is it possible for nothing to be displayed in those cells until something is input, thus triggering the formula?
cheers
I have a sheet which is locked, all bar a couple of columns for input. The cells in the locked columns display this all the way down to the last cell when waiting for an answer to be displayed, but it is hellishly ugly to see it like this. Is it possible for nothing to be displayed in those cells until something is input, thus triggering the formula?
cheers