Skip to main content
Question

ExcelStyler - how to highlight part of the text

  • February 21, 2024
  • 3 replies
  • 42 views

marta.podsiad
Supporter
Forum|alt.badge.img+9

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

 

3 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • 2000 replies
  • February 21, 2024

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)


marta.podsiad
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • 77 replies
  • February 21, 2024

 

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

 


virtualcitymatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • 2000 replies
  • February 21, 2024

 

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.