Bob Phillips' free add-in allows for more than 3 CF. You
can find it he

http://www.xldynamic.com/source/xld.....Download.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Good evening all,

I have a problem with trying to colour a range of cells,
dependant upon the entry of a certain value/text.
I need to be able to have 5 colours, and so CF regular
will not do.
I have a simple spreadsheet as seen below;


A B C D
01 CE
02 CO
03 IP
04 WA
05 WE

Simply put, as the values in Column A are manually
entered, I would like the row (A:D) to be coloured,
with each value, (CE,CO,IP,WA,WE), having a unique
colour.
I am familiar with VBA (though a novice), though this
seems that an event macro/vba may be needed.
I have been trying to use the code in dmcritchies super
site, but seem to be getting nowhere.
Any help here would be, as usual, most appreciated.

Cheers
Mathew




.