Skip to main content
Question

ExcelStyler - how to highlight part of the text

  • Feb 21, 2024 9:21 AM UTC
  • 3 replies
  • 85 views

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

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

itsmatt
Celebrity
Forum|alt.badge.img+48
  • Celebrity
  • Feb 21, 2024 10:00 AM UTC

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+12
  • Author
  • Supporter
  • Feb 21, 2024 10:25 AM UTC

 

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

 


itsmatt
Celebrity
Forum|alt.badge.img+48
  • Celebrity
  • Feb 21, 2024 10:41 AM UTC

 

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.