Conditional formatting or worksheet change event?
 

In column "D" I have text values of committed, targeted, and waiting.
Depending on what value is typed into a cell in column "D" I want the text
strings for cells in the corresponding row and columns "A" and "B" to change
to a different color.
For example, if a user types "Committed" in cell D1 I would like for the
text strings in cells A1:B1 to change to red.

I believe conditional formatting would be easier to use in this scenario but
I don't know if there is a formula that can be written to accomplish this.

Your help is greatly appreciated. I owe the experts from this site a debt of
gratitude.

BearsFan

Conditional formatting or worksheet change event?
 

select A & B and use a CF formula of

=$D1="Committed"

etc

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bearsfan" wrote in message
...
In column "D" I have text values of committed, targeted, and waiting.
Depending on what value is typed into a cell in column "D" I want the text
strings for cells in the corresponding row and columns "A" and "B" to
change
to a different color.
For example, if a user types "Committed" in cell D1 I would like for the
text strings in cells A1:B1 to change to red.

I believe conditional formatting would be easier to use in this scenario
but
I don't know if there is a formula that can be written to accomplish this.

Your help is greatly appreciated. I owe the experts from this site a debt
of
gratitude.

BearsFan

Conditional formatting or worksheet change event?
 

That's an easy one

Your conditional format statement in cell A1 will be something like this:

Formula is =$D1="Committed" (format to red)
Formula is =$D1="Targetted" (format to blue)
Formula is =$D1="Waiting" (format to green)

I have used $D1 rather than just D1 or $D$1 because now you can copy cell
A1, then go to a whole bunch of other cells in other columns, and use
EditPaste SpecialFormat.

Another tip: try playing with DataValidationList in column D. You just
have to type in Committed,Targetted,Waiting. Do you like that?

--
Allllen


"bearsfan" wrote:

In column "D" I have text values of committed, targeted, and waiting.
Depending on what value is typed into a cell in column "D" I want the text
strings for cells in the corresponding row and columns "A" and "B" to change
to a different color.
For example, if a user types "Committed" in cell D1 I would like for the
text strings in cells A1:B1 to change to red.

I believe conditional formatting would be easier to use in this scenario but
I don't know if there is a formula that can be written to accomplish this.

Your help is greatly appreciated. I owe the experts from this site a debt of
gratitude.

BearsFan

Conditional formatting or worksheet change event?
 

I knew that one was easy. Thanks for the assistance Bob and Allllen! Much
appreciated.

"Bob Phillips" wrote:

select A & B and use a CF formula of

=$D1="Committed"

etc

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bearsfan" wrote in message
...
In column "D" I have text values of committed, targeted, and waiting.
Depending on what value is typed into a cell in column "D" I want the text
strings for cells in the corresponding row and columns "A" and "B" to
change
to a different color.
For example, if a user types "Committed" in cell D1 I would like for the
text strings in cells A1:B1 to change to red.

I believe conditional formatting would be easier to use in this scenario
but
I don't know if there is a formula that can be written to accomplish this.

Your help is greatly appreciated. I owe the experts from this site a debt
of
gratitude.

BearsFan