Skip to main content
Question

ExcelStyler - how to highlight part of the text


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+36

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
  • February 21, 2024

 

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

 


virtualcitymatt
Celebrity
Forum|alt.badge.img+36
marta.podsiad wrote:

 

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings