Change Cell Background Colour

[Terry]

Some cells in my worksheet are fed from a dropdown (validation) menu. I
would like the background colour of individual cells to change automatically
depending on which item is selected from the menu. Is this possible with
conditional formatting or VBA? I'm very familiar with VBA in Access but
haven't yet ventured into the world of Excel/VBA. Could someone point me in
the right direction please?

TIA
Terry
WinXP/OXP (design) O2K (runtime)

 

[JE McGimpsey]

You can set up to four colors (normal background + 3 others) using
Conditional Formatting. See XL Help.

For more than three colors, check the archives at

http://groups.google.com/advanced_group_search?q=group:*excel*

where you'll find dozens of ways.

 

[Terry]

Ok, got that sorted. Thanks.

Further to this, is it possible to use the Right() function within
conditional formatting? I want to change the color only if the last three
characters match my condition. Right(*cell reference*,3)="O/T" doesn't work
and a search on google groups has so far been fruitless.

TIA
Terry

 

[JE McGimpsey]

One way:

CF1: Formula is =Right(A1,3)="O/T"

 

[Terry]

I tried that. Hence, my earlier: Right(*cell reference*,3)="O/T"

At least i think i tried it as you suggested....

I added it to the CF dialog box following Cell Value is | equal to |

it didn't work, am i missing something?

Thanks again
Terry

 

[Terry]

I have accomplished my task using VBA with the help of davemcritchie's
geocities excel pages, for which i am grateful..

Thanks very much for your help and direction, Mr McGimpsey.

Terry