Formula flag:
=IF(A2=A1,"","New Name")
copy down.

Conditional format:
Select all the cells (A2:A100), with A2 being active cell. Conditional
format, formula is:
=A2<A1
Set formatting.
Ok out.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ken W" wrote:

I have a long list of data that is sorted by name. The total list is about
500 rows, of those could be five to 10 of one name before it switches to a
new name. I would like some kind of change to let me know that the new name
has begun. I was playing around with conditional formatting, as I thought
that would do it for me, but I don't know much about it and I couldn't make
it work for me. However, it seems like the answer is there somewhere.