Hi In XP Excel 2000 I Have a Vallidated List on a Sheet named (CODES &
Abrieviatons ) I have Named that List as (CODES_Abriev's)
I have 3 groups of "Decribing Abrieviations" colour Coded Eg: B7 to B9 =
Describing different types of Pipe Laying EG:

Water-Pipes is Green: [ Pipes-Water/{1}EW) ]
Pipes Storm Water: [ Pipes- Storm/{}) ] and
Sewer Pipes as [ Pipes- Sewer/{}) ] Then the List contiues:

Pit's is B10 to B27 Blue

Then "Pieces": B28 to B40 in Orange

In the list they are Colour Coded & Formatted ) a Cell in a blank Cell as an
Indicator when scrolling the Dropdown List showing ***** in Blue Meaning the
Start of Pit's Data: Then ***** In a Cell Before "Pieces" How Do I get each
one to enter in their original Colour's after selecting it in the Dropdown
List on Sheet:(CODES & Abrieviatons ) And enter it in the (TENDER TEMPLATE x
1) Range Named (CODES B15 to B150) in it's original Colour Code? Any help
would be gladly recieved Guy's thank you