Change the text font

Hello,

how to automatically change the text font (e.g. color red) to the left of the columns if it matches the characters on the right?

When done manually it looks like this:

color.jpg

The left values is typed into the cells.

Originally Posted by 6StringJazzer

See attached. This will work for any number of rows but if the format in your actual file is different then the code will have to change.

Hello,

I will paste values to your file. It will be as template.
I’ve been using this for a while now

I have a request for such a modification:

1. Add an additional Designators column (J) (as an example M and N columns). Then use different buttons (as an example "Color References T" and "Color References B") to change the references colors of the T and B values.
if the value in the column "References" is in the column "Designator T" - the color is green
if the value in the column "References" is in the column "Designator B" - the color is red


2. (If it is possible) Add a separate button to expand the values (from - to) in the References column.
For example:

C1, C3, C5-C9, C14 --> C1, C3, C5, C6, C7, C8, C9, C14


3. Calculate how many "References" values are green and how many are red (as an example C and D columns) (there may also be a separate button).

I performed these steps manually. It would be great if it could be automated.
Thank you very much for the work you have already done.