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

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

Guest

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.
 
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".
 
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.
 
You must log in or register to reply here.

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

Code to format cells on several worksheets 2
protect cell format 1
how to use "text" in "if then" condition 1
Copy format of cell from other worksheet 4
Concantenate which keeps bold of some parts. 5
Target cell reference moves when target is cut and pasted 5
keeping only data in cell and not formula 2
Formula with Cell reference to include formating? 13

Back
Top