M
MPB
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
) 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
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
) 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