---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SIMPLY PUT: I WANT EXCEL TO LEAVE THE CELL BLANK WHEN IT ENCOUNTERS THE FIRST ZERO IN COLUM D - AND CONTINUE ON THE NEXT LINE (WITH THE SAME DATA) - SO I CAN HIGHLIGHT THE ENTIRE ROW AND VISUALLY SEPARATE THE TABLE.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I want to insert one cell line across a table of variable data, when the numbers in column D turn zero. I want to visually separate the table when numbers turn 0 along column D. Once numbers turn zero, it stays zero for the column. The data is linked so the whole line of data has to shift down, and continue on the next line. I'm thinking of shading in the line with colours to indicate where the change occurs.
Also is it possible for me to specify where the blank row is inserted - just before the 1st, 2nd, 3rd,....... "0" encountered in column "D".
Thank you
Other posts:
Shift cells one line down - when column d numbers turn zero
