Try Chip Pearson's ROWLINER add-in. Fully customizable.

http://www.cpearson.com/excel/RowLiner.htm


Gord Dibben MS Excel MVP

On Wed, 5 Mar 2008 09:22:00 -0800, Shannon
wrote:

I used the coding from your first example and that works; however....

I also have a conditional format on all the rows to highlight every other
row. The coding for that is: =MOD(ROW(),2)

The problem is that the coding to highlight the active cell's row does NOT
overcome the conditional format highlight. It does work on the rows without
the conditionally formatted highlight.

Is there a way to make this "highlight the active cell's row" code highlight
the rows that also have the conditional formatted highlight?