In Column A, How to I insert lines for whenever the values change for the
entire row A:AS.

Pears
Pears
Pears
Apples
Apples
Oranges
Oranges

I tried conditional formatting, but I only figured out how to use it for a
specific cell, not a row, and only for specific cells -- not relative to
changes to the cell above...

thanks very much...