Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping text color format in a list
I've created a list and I want to keep the text color format. I have a list
of 100 items. 25 have blue text, 25 red, 25 yellow, and 25 green. I created a list if these text items. When I select the cell I want to insert a list (though DataValidation) all my list items are the default black text. How can I keep the colors in the list? Thanks, Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping text color format in a list
Data|Validation won't let you bring colors back. (Samething with a formula,
too.) But since you're only using 4 colors, could you use Format|Conditional formatting to change the color? You could use 3 colors via Format|Conditional formatting and then the normal color for the 4th. I'd add a helper column adjacent to the list column. Say the list is in Sheet2 in A1:A100 I'd insert (and hide???) a new column B that contained the color that I wanted. Red Blue Yellow Green Then give those two columns a nice range name (insert|Name|define, call it myTable). Then you could set the color of the cell with the data|validation to always show a green font (default). But add 3 conditions under Format|conditional formatting. Say A1 is the cell with Data|Validation Formula is: =(vlookup(a1,mytable,2,false)="red") and format it red Then add 2 more conditions with similar rules. If you upgrade to xl2007, the number of conditional formatting rules is 64 (I think). Strike Eagle Loader wrote: I've created a list and I want to keep the text color format. I have a list of 100 items. 25 have blue text, 25 red, 25 yellow, and 25 green. I created a list if these text items. When I select the cell I want to insert a list (though DataValidation) all my list items are the default black text. How can I keep the colors in the list? Thanks, Chris -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping Text format | Excel Worksheet Functions | |||
Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
How do I convert dates to text keeping the format? | Excel Discussion (Misc queries) |