Highlight entire row between 2 non empty cell

Is there a way to highlight entire row between non empty cell? I just want a macro code for it and perform group to expand and collapsed it anytime .

Refer to Column D please,between those word are empty cell and I want to group it so I can expand and collapsed it

Hi there @ Sixthsense , when I try to embed your code,what only happen is that the code remove the color blue background on row 1, If you refer on Column D, I want to group the words between "Total Assets" to "Liabilities","Liabilities" to "Net earnings", or any words that appears. I hope I explain it well. Thanks

Ah I see,i get it now,sorry if you misunderstand my post,I just want to select the empty cell between words downward and perform group and ungroup for me to easy collapse and expand.

Hi @JosephP thanks for the code you given me,it works now,however I just need to group also other column aside from Column D,if you notice the number on Row 1 in the workbook I attach,I just need to group that from Column D to N(number 12). When I try to modify the code to group other columns by row, it turns out to be messy .

Hi,I'm going up this thread.Need help badly,I manage to embed the code that Mr JosephP given to me,I want to group by row(from Column D to N),with the help of his code. But then something is not right since it start to group blank cells of row 2 before the non empty cell. I hope you get the point what I am trying to explain . Try to see the new attach workbook

Wow,there is a limit of nested grouping,anyway, is there a way to start a nested grouping after the 1st word found in a column. For example on my 2nd workbook attach on "Column H" from row 2 to row 18, I don't want to include that on grouping rather if the 1st word found(1st non empty cell found) it would start to group the non blank cell below.