Changing Cell Colour

I am trying to get cells to change to a preset colour when a particular 3 digit code is entered. I can get 3 colours using conditional formatting but need to have 6. Is this possible using another formula?? Can anyone help.

Cheers

Jez

Hi,

With VBA, you can have multiple conditions and multiple colors ...
you are no longer limited to the 3 conditions of standard conditional formatting

see attached

HTH
Carim

Thanks for the help so far. If I want to specify colours for 6 3 letter codes (LTH, MBA, RKE, AHO, BGL, DHO) who do i go about altering the code as yours is set to 26 single letters as I'm not sure how to get the table ref in. See attached exmaple.

Cheers

Jez

hey guys....
i wanna ask something which relates to this particular thread...
the example codes and worksheets that you guys posted, i havea question regarding that. I can't seem to get mine working, cause i don't raelly know how to automatically assign it to my worksheet,i.e. do i need to setup a button or a command switch ?

regarding the respective colour index, do you may have a list of all the colours ?

thanks in advance
cheers guys

Originally Posted by VBA Noob

Hi,

Add the code to the sheet you want the changes to happen in e.g Sheet 1 . See attached link

http://www.contextures.com/xlvba01.html#Worksheet

VBA Noob

hey VBA Noob...

thanks for the reply, but it still won't run. do i have to activate anything ? cause i followed the guide from the link, still stuck

cheers

Hello.

I have tried the routine and it works. I have a problem with one of it's features though.

Please Login or Register  to view this content.

I want to compare the values to in the target range to a cell D3 in another sheet called "Settings". How can I do that? The value in cell D3 is "705".
I also want be able to format the target range in case I write "OK" in the target range.
What I can see in this code is that it only accepts integer values? How can I change it so that it accepts any kind of values?

/Anders