Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color alternate Entire row dependant on value in "A"
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Shading alternate "groups" of rows? | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? | Excel Discussion (Misc queries) | |||
set "value if true" to "fill cell with color" | Excel Programming |