Is it possible to reference a cell which contains "ABC" where B is blue and C is yellow while keeping the color formatting?
Assume A1 contains the colored text, then I want B1 to refer to A1 and maintain the colors.

A similar question was asked 3 years ago, but the answer seems to be not working anymore.

  • Meta question about this one
    – user55949
    Commented Apr 18, 2019 at 10:05
  • @JanDoggen this is not a duplicate. the link in Q is mistakenly referenced as "something similar from past" but it's not. This Q deals with multiple colors in one single cell (which is not possible to achieve) while referenced post deals with a single color for font and a single color for the background (which is still possible to achieve)
    – user0
    Commented Apr 18, 2019 at 14:02

1 Answer 1


Transferring multiple individual colors from in-one-cell to another cell is not possible at this current version of the Google Sheets (nor at any previous versions):


  • 1
    There was a questions 2~3 years ago which is similar to this one. I tried to duplicate the answers but it seems like they no longer working. webapps.stackexchange.com/questions/50409/…
    – Alex
    Commented Apr 18, 2019 at 9:33
  • @WeiZheng indeed, however, that is something else. having ABC in more than 1 color is not possible to reference anyhow. on the other hand, referencing cell which has 1 font color and 1 background color is possible via scripting to be referenced
    – user0
    Commented Apr 18, 2019 at 13:53
  • 1
    oh I see, thanks for the help!
    – Alex
    Commented Apr 18, 2019 at 23:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.