Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can u make a text in a cell to blink , or change it's color? | Excel Worksheet Functions | |||
Change selection color | Excel Discussion (Misc queries) | |||
Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
How can I delete source links and change the current sheet accord. | Excel Worksheet Functions | |||
How to make text to change its color accord. to selection from a l | Excel Discussion (Misc queries) |