I have a formula that brings cell values from Sheet 1 to Sheet 2. If a cell is on Sheet 1 is empty, the result on Sheet 2 is a 0. I want to conditionally format the cells to hide the 0 that results from an empty cell. HOWEVER if Sheet 1 has a 0 and the result on Sheet 2 is that 0, I want that 0 to be displayed.
Is this possible using Conditional Formatting or does Excel treat all zeros (true 0 and empty cell) equally?
Please help.
Bookmarks