Contional Formating In VBA (More Than 3 Rqd)

[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

 

[Jason Morin]

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

http://www.xldynamic.com/source/xld.CFPlus.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) 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.

 

[MPB]

Nice one Jason
Thank you
M

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

http://www.xldynamic.com/source/xld.CFPlus.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) 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.