| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cond. format text color based on another's text color
I want to copy text from A1 to C1, and if A1 text is red, then the copy
should be black(automatic), and vice versa. Can I do this in conditional formatting, or do I need to go to VBA? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cond. format text color based on another's text color
VBA.
-- Brevity is the soul of wit. "manxman" wrote: I want to copy text from A1 to C1, and if A1 text is red, then the copy should be black(automatic), and vice versa. Can I do this in conditional formatting, or do I need to go to VBA? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cond. format text color based on another's text color
OK. Would you briefly tell me how? I am a newcomer to VBA, but willing to
learn. Thanks for the help. "Dave F" wrote: VBA. -- Brevity is the soul of wit. "manxman" wrote: I want to copy text from A1 to C1, and if A1 text is red, then the copy should be black(automatic), and vice versa. Can I do this in conditional formatting, or do I need to go to VBA? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cond. format text color based on another's text color
Ahh, that's the $64,000 question.
I'm not sure how, as I'm a relative newcomer to VBA as well, however, this web site has a wealth of information about colored cells and VBA: http://www.cpearson.com/excel/SortByColor.htm Dave -- Brevity is the soul of wit. "manxman" wrote: OK. Would you briefly tell me how? I am a newcomer to VBA, but willing to learn. Thanks for the help. "Dave F" wrote: VBA. -- Brevity is the soul of wit. "manxman" wrote: I want to copy text from A1 to C1, and if A1 text is red, then the copy should be black(automatic), and vice versa. Can I do this in conditional formatting, or do I need to go to VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Color Change prompted by different columns | Excel Worksheet Functions | |||
| Conversion to Text file format error | Excel Discussion (Misc queries) | |||
| How do I use cond format formula to set cell text and color? | Excel Discussion (Misc queries) | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
