I created a conditional format to highlight only the line (column A thru I) after the last entry in column H when a cell on that line is selected. However, instead of highlighting the columns A thru I on that row, it highlights only row A on that line and columns B thru I on line 2. If I change -2 to -1 the split line appears on row 1 instead. This is far from the first time I have used conditional formatting, but it is the first time I have used Count in formatting
.
.