Copy text cell & change text color conditionally

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)?
 
The color of the text is completely independent of its value. The same
number is red in some cells, and black in others.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations Help 4
Background color change, by using the formula. 1
Conditional Formatting macro: simple, but doesn't work 6
How do I use Conditinal Format for another cell? 1
Conditional formatting based on numbers in columns 5
Formula Help Needed (Sum and If Then) 1
Trouble with conflicting IsBlank() and CountBlank() results 4
Change a cell's color based on return value of a formula 4

Back
Top