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