Excel: Highlight

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.

For more resources for Microsoft Excel