Thank's Very much Ken and thank's for your time, Just what I needed, Dasha
"Ken Johnson" wrote:

On Nov 4, 9:11 am, Dasha wrote:
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

Maybe conditional formatting in the cells with the data validation
dropdown.

Con Format 1: FormulaIs: =LEFT($B15,3)="Pip", Format:Green
Con Format 2: FormulaIs: =LEFT($B15,3)="Pit", Format:Blue
Con Format 3: FormulaIs: =LEFT($B15,3)="Pie", Format:Orange

Ken Johnson