Macro for changing color of individual characters in a cell in calc? [closed]

asked 2014-02-23 10:44:45 +0200

Tal gravatar image

Hi. I'm trying to write a macro that will change the color of individual characters in calc, depending on which letter they are. I can change the color for the entire cell's text, no problem. But I can't figure out how to manipulate the color of just the i-th char. (it is very easy to manually color just a subset of the string in a cell, so I know calc is able to handle cells with multiple colors).

I'd appreciate any help.

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:58:09.826346