Change Cell Background Colour

  • Thread starter Thread starter Terry
  • Start date Start date
T

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)
 
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
 
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
 
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
 
Back
Top