set the cells to one of those colours by default, then use CF on the other 3
values/colours.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mel" wrote in message
ups.com...
I have a spreadsheet that will have up to 20,000 lines on it.
A1:K20000. Cell I2 is the cell that I use for the line color.
It will have 4 possible options. 'I', "H", "O", "C".
(Would like to use a drop down list if that would work with the line
formatting.)

H=Red (#40), O=pale yellow(36), I=green, C=light blue

I know I cannot use conditional formatting as I have 4 colors.
Not exactly sure how to write up the code for this one.
Any help would be most appreciated.
thx

Mel