Changing font colour based on a character

Hi Guys

I have a list of values that are output to cell D67 in the form of

Name1, Name2

or

Name1, Name2, .... Name10, Name11

or

Name1, Name2, ...,,,,,,,,,,,,,,,,,... Name30, Name31

Number of names varies but each one is separated by a comma

Is is possible to change the font colour after each comma

Name1, Name2, .... Name10, Name11


Thanks for looking

Try this

Please Login or Register  to view this content.

Hello jindon

Thanks for your help

I have added your code but the output is not changing I added it as a module.

Dose D67 contain formula?

If so, you need to convert it to Value.

Can not partially format the cell when it has formula or numeric value.

Yes it does sorry

Hi Jindon

I am having trouble converting to text, can it be done within your code by adding

D67 = CSTR(D67)

I don't seem to be able to get it to work
Thanks for your help

Add one line

Please Login or Register  to view this content.

Range("D67") and [D67] are the same in this case.

Hi Jindon


I am still having no luck

I have uploaded my workbook to https://onedrive.live.com/redir?resi...=folder%2cxlsm

as I cannot attach it here,

as you will see I have now moved to cell C11

Thanks

You should re-build a workbook.
It tells only 304k in the property, but takes a few minutes to open and says , fixing and opening....

Please Login or Register  to view this content.

Thanks again, I have added as a module but I am still not able to get it to work

.............................

thank you I will rebuild and see

your help is greatly appeciated

Apologies shg

I need to see your re-build workbook to know how you update C11.

I couldn't open your uploaded file properly.

Hello Jindon

Thanks again
I have uploaded my rebuild to https://onedrive.live.com/redir?resi...nt=file%2cxlsm

\the cell c11 is updated based on the value in B5 and so I need some way to convert back from values so it will update

Add the code to sheet module

Please Login or Register  to view this content.

The code will execute only when you change any value in f23:f61, since the formula in D67 calculates that range.
And the code will convert C1 formula to value, C1 will never change unless you enter =D67 mannualy again.

Are you expecting changing the format with formula intact?, That's simply impossible.

Ok, now I understand, thanks so much for all your help, your code has taught me some new techniques I was not aware of

Sorry to have taken up your time

No problem.