| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy text cell & change text color conditionally
I want to copy text from cell A1 to cell C1, and if the text in A1 is red,
make C1 black, and vice-versa. There is no formula in A1. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy text cell & change text color conditionally
It should be possible with VBA code, but an easier option might be
conditional formatting. Is there anything specific about the value in A1 which determines the colour? Could you use this property to set a formatting condition (eg is it red for negative numbers, black for positive. Is it anything to do with the content eg part of the text, length of the string etc)? -- Ian -- "manxman" wrote in message ... I want to copy text from cell A1 to cell C1, and if the text in A1 is red, make C1 black, and vice-versa. There is no formula in A1. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy text cell & change text color conditionally
The color of the text is completely independent of its value. The same
number is red in some cells, and black in others. "Ian" wrote: It should be possible with VBA code, but an easier option might be conditional formatting. Is there anything specific about the value in A1 which determines the colour? Could you use this property to set a formatting condition (eg is it red for negative numbers, black for positive. Is it anything to do with the content eg part of the text, length of the string etc)? -- Ian -- "manxman" wrote in message ... I want to copy text from cell A1 to cell C1, and if the text in A1 is red, make C1 black, and vice-versa. There is no formula in A1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Cell text color change | Excel Discussion (Misc queries) | |||
| Excel VBA - Trying to change color of cell conditionally | Excel Programming | |||
Linear Mode
