Highlight a specific amount of characters in a cell

Only way to highlight (bold etc) part of string in a cell, is by hand or by VBA.
Ex:

Please Login or Register  to view this content.

Note: Just a demo. So if you edit cell. Code should be re-run while range is selected. You could write event code. But I wasn't sure of your data location etc.

As for highlighting when character count goes over 150... you can use conditional format.

Assuming Column A, and data starts on row 2. Select data range. Conditional format -> New Rule. use a formula to determine...
=LEN($A2)>150

Set fill color as desired.

Hi hassified and welcome to the forum,

If you select a single cell and use the formula bar and select some characters, you can change the color or font of those individual characters. In VBA the code is for Characters. See https://docs.microsoft.com/en-us/off...cel.characters
I believe you would need to write some VBA code to go through each cell in your column and change the first 35 characters to bold.

I think you would be better off by having a helper column of the first 35 characters of your original string using the Left() function.

Here is some code to turn the first 35 characters of the string in cell A1 to bold.

Please Login or Register  to view this content.

It is interesting that when only some of the characters are bold then asking if the whole is bold or not, the answer is "Null" instead of True or False using a Debug.Print Cells(1,"A").Font.Bold = True in the immediate window.

Thank you MarvinP. I have used your code and like how it BOLDS the first 35. But the unBold code loses me. Does it need to be?

I used the code like this:

Formula:

Please Login or Register  to view this content.

I added the first bit of code so I can have it run anytime I change the cell automatically. The only not so big issue is, when I delete/clear the text from the cell and type in new, all the text is in bold. I have to turn off the bold in the font tab. Is there a way around this?

Try

Please Login or Register  to view this content.