| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make text color match cell color with macro?
Let's say I have a series of cells filled with different colors. Each cell
also contains a number used for sorting. (I've heard you can sort by color alone, but we haven't gotten that far yet). Can anyone suggest a macro that will "look at" the cell fill color, and format the text to the same color so it's invisible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Make text color match cell color with macro?
You can make your life more difficult by putting that stuff all in one cell, but
why not just use an extra column. You can use that extra column as one of the sort keys. Then if you don't want to see it, you can hide that column. JoeSpareBedroom wrote: Let's say I have a series of cells filled with different colors. Each cell also contains a number used for sorting. (I've heard you can sort by color alone, but we haven't gotten that far yet). Can anyone suggest a macro that will "look at" the cell fill color, and format the text to the same color so it's invisible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
| Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| Macro to change cell text color | Excel Discussion (Misc queries) | |||
Linear Mode
