colorof one cell depends on content of another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manuel Murieta - 26 Mar 2007 18:18 GMT

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".

Reply to this Message

Bob Phillips - 26 Mar 2007 18:48 GMT

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

Signature

HTH

Bob

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

>I have a worksheet where C3 contains a dropdown menu of 8 items, for
>example radio,tv,microwave,stove,other.
[quoted text clipped - 15 lines]
> and I would like F4 to change from locked to unlocked only if C3 contains
> the words "Spouse", "Relative", or "Other".

Reply to this Message