The free Excel add-in "Shade Data Rows" will shade by cell value.
It shades the selection or across entire sheet.
It will also shade by every nth row or every group of n rows.
Choice of any color.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"Les" wrote in message ups.com...
Hi, i have document numbers in column "A", all like numbers must be the
same color e.g.
rows 1, 2, 3, 4 white then 5 grey, 6 white, 7 & 8 grey etc..
I would like to do this with code as the length of data is variable and
automatically created..

1.A03697 1712 7531581 ASSY HSE BTW RADIATOR RETURN & THERM/HSG
2.A03697 1362 1433077 TEMPERATURE SENSOR WATER, CLIPSE ATTACHM
3.A03697 6111 6938076 MDL TEMP SENSOR E9X N46+NG6/N52
4.A03697 1713 7543026 AY COOLANT EXPANSION TANK L2 SP-IG.ENGIN
5.A04933 3610 6775592 STEEL WHEEL 7JX16 EH2 IS34 STYL 12)
6.A07050 5175 7128503 SEAL RADIATOR
7.A07110 2120 9901023 PAN SCREW M8X16-8.8-ZNS
8.A07110 2151 1203012 KNURLED-HEAD BOLT
A07346 5121 7059891 LU UNIFORM LOCK SYSTEM LHD
A07346 6612 6937508 ADAPTER PURSE KEY PL2
A07346 5116 7075474 ASSY GLOVE BOX CPL A COL
A07684 6113 9129853
A07904 3452 6767984 PIPE CLIP ABS PAD WEAR IND. CABLE