Use CF with a formula of

=A1<A2


--
__________________________________
HTH

Bob

"carolm" wrote in message
...
I have a list of locations that repeat for a varied number of rows
depending
on other data. I want to shad the first instand of the new value so its
easy
to see when the location changes. How can I accomplish this?