Skip to main content
  • EN

Hi,

 

Is there a way to change the color of the font for the part of the text that matches regex? In the scenario below I would like to put in red only the double spaces in Excell

 


At the moment is highlighting the whole text in excel

 

is this something you can do in excel?

I’m not quite sure what red space would look like hehe. I did try to use the highlight function in excel but it was only able to highlight the whole cell. 

I was able to format a Strikethourgh which I was then able to color (I didn’t try with FME though)

 

I require FME to generate a report where specific portions of the text are highlighted.

 

 

I require FME to generate a report where specific portions of the text are highlighted.

 

Sorry I mean - is this something that Excel even supports - I was unable even to do this directly in excel let alone in FME. If you’re unable to even do it directly in excel then I don’t think FME will support it.

Reply


Community Stats

30,362
Posts
115,380
Replies
38,092
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.