Hi all,

I have a large data sheet made of 8 columns (A:H) and over 45000 rows.
Data are sorted into sets of variable number of rows. Each set of data is separated from the following with one blank row.

I am in need to only highlight all the FIRST ROWS of those data sets. In other words, I need to highlight the first row after every empty row.

The follwoing code highlights only the last row in the data sets, but what I need is the reverse.

Sub HighlightLastRow()Range("A1:S" & Range("A" & Rows.Count).End(xlUp).Row).FormatConditions.Add(xlExpression, xlEqual, "=OFFSET($A1,1,0)=""""").Interior.Color = vbYellow End Sub
May I get some help with this question please?

All the best

M.