View Single Post
  #1   Report Post  
I hope you can help
 
Posts: n/a
Default How do I keep formats (eg.color) when making a relative reference

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.