How to make text to change its color accord. to selection from a l

[Gary Brown]

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

 

[Gary Brown]

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

 

[Ammar N]

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

AN