I have a excel spreadhseet, where in I have two products namely DCE and RF, which are in Column A, under neath those are some rows, which I need hilighted. But if the row is empty, I dont want it to be filled with a color,
So for example
Row 50 - has the word DCE and under neath it has 4 rows, then one blank and another 4 and so on
After about 100 rows, there is another product RF, and it has the same scenario
I have two spreadhsheet like this, but the 2nd spreadhseet has the same product but in different rows. How can I do that
Any guidance would be appreaciated
Thanks
So for example
Row 50 - has the word DCE and under neath it has 4 rows, then one blank and another 4 and so on
After about 100 rows, there is another product RF, and it has the same scenario
I have two spreadhsheet like this, but the 2nd spreadhseet has the same product but in different rows. How can I do that
Any guidance would be appreaciated
Thanks