Share via

"Find and Replace" function automatically changes the text´s color

Anonymous
2025-01-31T05:52:33+00:00

Hi, I was using the "Find and Replace" function on a cell where I have several lines of text, each line with different colors. I wanted to change the text of one line in the cell, so I use the "Find and Replace" function, but then all the lines in that cell automatically changed the color to green. Is there a way to solve this?

Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2025-01-31T12:10:06+00:00

    In the desktop version of Excel for Windows and Mac, it would be possible to create a VBA macro for this purpose, but VBA does not work on Android.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-01-31T10:43:37+00:00

    Hi HansV,

    this is also the only solution I found, too bad, I was hoping there could be an alternative...

    Thank you!

    Ilaria

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2025-01-31T10:35:31+00:00

    Replace will always remove character formatting.

    You can use Find to locate cells with the line, then edit the cell manually.

    Was this answer helpful?

    0 comments