Thanks Paul. While there is no pattern (it's a list of Farmville neighbors with some shaded green as good neighbors, others pink as bad neighbors and no shading for a few others), I could add a number 1 or 2 to the shaded cells. Having next to no experience with macros, it might take a little time for me to try and figure it out. If I have questions, I'll post in the appropriate macro area.