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