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

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" <(E-Mail Removed)> wrote in message
news:9CCE6EE0-0998-43D9-8B10-(E-Mail Removed)...
> 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
>

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
Edit>Paste Special>Format.

Another tip: try playing with Data>Validation>List 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
>

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" <(E-Mail Removed)> wrote in message
> news:9CCE6EE0-0998-43D9-8B10-(E-Mail Removed)...
> > 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
> >
>
>
>