Font Colour in Comment

[AlexanderBB]

I believe this changed in Excel 2007 (from 2003) where this worked

 .Characters(1, l).Font.Color = RGB(153, 51, 0)

I thought it was now .Font.ColorIndex but that didn't work either.
Also, is there any way to debug.print all elements before ".Characters" to check what they are?

Thanks.

 

[AlexanderBB]

Maybe. I was hoping someone else might have chipped in, to verify yours or my results.
Thanks for helping !!

 

[Michael M]

Sorry I couldn't help, but there may be a little assistance here

https://www.excelcampus.com/tools/excels-color-palette-compatibility-solution/

https://answers.microsoft.com/en-us...n/af64f8f6-94e9-4095-a45b-e1b36b9f6601?auth=1