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
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of July 30, 2014.