Hi all, i am able to change every other line color but i need to do it a
bit differently with VBA. For every new number in column "A" i need to
alternate yellow and no color. see example below.

gAMS No gAMS Description
AAB05U HA-Getriebe--- Yellow
AAB05U HA-Getriebe--- Yellow
AAF15U BlowBy-Einleitung in Luftfuehrung N54--- White
AAJ28U Getriebeoelkuehlerruecklaufleitung---Yellow
AAK45U Getriebekabelbaum N46 OL RL--- White
AAK78U Schalthebeltilger PL-2 M47---Yellow
AAW81T QUAKO AFS Lenkhilfekuehler PL2--- White
AEX31U QUAKO- Kopfsstuetze PL2 Leder ohne Watte--- Yellow
AEX31U QUAKO- Kopfsstuetze PL2 Leder ohne Watte--- Yellow
AEY08U Quako: Cost Down Massnahme Radio Stufe 1---White

Any assistance with code would be appreciated...


Les Stout

*** Sent via Developersdex http://www.developersdex.com ***