Contional Formating In VBA (More Than 3 Rqd)
 

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

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




.

Nice one Jason
Thank you
M

"Jason Morin" wrote in message ...
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




.