Colorizing part of text in a string variable

**Prarne** · 03-04-2020, 04:39 PM

Hi good People!

I am looking for a way to colorize text in a textvariable. I am listing a range of events in a textbox containing a timestamp and an eventname. The Source also has information of the soure for the event, either phone, email or chat. I would like to put individual colors on the text depending of the Source. Or even better, include a symbol in the string with customized color for each event type.

I fill the textbox simply like this:

Please Login or Register  to view this content.

Any way my wish could come through?

Best regards
Prarne

**Norie** · 03-04-2020, 05:37 PM

Prarne

You can't format a string but you can format the text displayed in the textbox.

Can you post some sample data and indicate the formatting you would want to apply?

**Prarne** · 03-04-2020, 08:15 PM

Hi Norie - thanks for rapid response!

The data consists of a simple table With Events, timestamp and Source, eg. 'Printer problem', '04.03.2020 15:12:23', 'Phone'

The routine takes the 12 latest rows and lists them simply in the textboks using a fixed font (Courier New Times) like this:

04.03.2020 20:28:09 - Printer problems
04.03.2020 20:26:43 - Network issues
04.03.2020 13:08:17 - Permission denied

The preferred solution would be to replace the dash between the timestamp and the event text with a bullet point colorized dependent of the Source Field, either 'Phone', 'Mail' or 'Chat' (green,orange or yellow). Alternatively the text or background could be colorized, but that could be rather painfull to look at :-).

The dash will always be in the same position in each line of text (pos 22)

Best regards
Prarne

Colorizing part of text in a string variable

LinkBack

Thread Tools

Rate This Thread

Display

Colorizing part of text in a string variable

Re: Colorizing part of text in a string variable

Re: Colorizing part of text in a string variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to create a self-adjusting formula to extract variable sized part of a string

Storing complex text string into variable. Text string contains html or xml code.

Is it possible to find out if any part of a text string appears in another text string?

Colouring variable text within a cell / string, and merging a variable number of cells

[SOLVED] Can I remove the first part of a string of text and keep the second part?

Match text in A1 to a part of a text string in B1 and enter data D1

How to get set of chars from a string to a variable. Part II

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions