ExcelBanter - How to make text to change its color accord. to selection from

Gary, I was having the same problem. Thanks so much!!!

AN

"Gary Brown" wrote:

Assuming you are using Data Validation to create your drop-
down list in B1...
To change the font color in depending on the selection,
highlight cell B1.
Select 'Format' then 'Conditional Formatting'.
Condition 1 should be:
Cell Value Is
equal to
="Neutral"

Select the 'Format' button next to the box that says 'No
Format Set'. Select 'Font' then 'Color' then the color
Blue, then 'OK'. (You might want to make it Bold also)

Select the 'Add' button and Condition 2 will appear.

Repeat the above items for the 2nd and 3rd conditions then
hit 'OK'.

Condition 2 should be:
Cell Value Is
equal to
="Positive"
Select the 'Format' button next to the box that says 'No
Format Set'. Select 'Font' then 'Color' then the color
Red, then 'OK'. (You might want to make it Bold also)

Condition 3 should be:
Cell Value Is
equal to
="Postponed"
Select the 'Format' button next to the box that says 'No
Format Set'. Select 'Font' then 'Color' then the color
Green, then 'OK'. (You might want to make it Bold also)

HTH,
Gary Brown

-----Original Message-----
Hello Gary,

unfortunately, i did not understand youre suggestion.
let me restate my question.
in cell b1 i have a drop-down list containing 4 possible
options (positive,
negative, postponed, neutral). i want to make it so that
when we choose, for
example, "neutral" it aapears it the cell B1 as blue.
when i choose
"positive" from the list in B1 it appears "red" in the
same cell. when i
choose "negative" from the list in B1 it appears "black"
in the same cell.
And, finally, when i choose "posponed" from the list in
B1 it appears "green"
in the same cell.

"Gary Brown" wrote:

Conditional Formatting has 3 conditions. Using all 3
plus
the default black font will give you your 4 choices.

Say your worksheet contains columns A to D and column B
has the 4 possible options. To change the font color
in
all cells on a particular row, highlight columns A to
D.
Select 'Format' then 'Conditional Formatting'. Change
Condition 1 from 'Cell Value Is' to 'Formula Is'. In
the
next box, put the formula
=$B1=2
Select the 'Format' button next to the box that
says 'No
Format Set'. Select 'Font' then 'Color' then the color
RED, then 'OK'.

Repeat this for the 2nd and 3rd conditions.

HTH,
Gary

-----Original Message-----
Hello everyone,

I have a drop-down list consisting of 4 possible
options...
Excel automatically sets black color for fonts....
Is it possible to apply different colors to different
options?
in other words, in the choice is 1 - black, 2 - red,
3 -
green, 4 - yellow

thank you in advance
.

.