colorof one cell depends on content of another

[Manuel Murieta]

I have a worksheet where C3 contains a dropdown menu of 8 items, for example
radio,tv,microwave,stove,other.

I would like B2 to change color if C3 contains the word "other"
and I would like B3 to change from locked to unlocked only if C3 contains
the word "other"

I would also like someting similar for another groupd of cells, that is the
following

F3 contains a dropdown menu of 4 items: Self, Spouse, Relative, Other
I would like E2 to change color if F3 contains the word Spouse, Relative or
other
I would like E2 to change to the word Spouse if F3 contains spouse
I would like E2 to change to the word Relative if F3 contains Relative
I would like E2 to change to the word Other if F3 contains Other

and I would like F4 to change from locked to unlocked only if C3 contains
the words "Spouse", "Relative", or "Other".

 

[Bob Phillips]

Use conditional formatting for the colouring. See
http://www.contextures.com/xlCondFormat01.html
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)