How do I keep formats (eg.color) when making a relative reference

  • Thread starter I hope you can help
  • Start date
I

I hope you can help

When you have text in a cell (eg. A1 has "Correct") that is colored green and
in another cell (eg. b1) you have a formula refering to that cell "(eg.
"=A1") how do you get the formula to keep the format of the referenced cell.
 
E

Earl Kiosterud

It doesn't. YOu have to pretty much format each cell as needed. YOu could
use Conditional Formatting in the formula cell, setting it to turn green if
the cell is "Correct".
 
I

I hope you can help

Conditional formating will work but what I was really doing is concatenating
various cells together and trying to keep all the unique colored text. (eg.
Cell B1 would be =A1&A2&A3 and A1 would have red text, A2 would have green
text and A3 would have blue text).

It looks like I will have to build a macro.
 
Top