Identifying changing data in a list

  • Thread starter Thread starter Ken W
  • Start date Start date
K

Ken W

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.
 
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.
 
Back
Top