vzachin
11-21-2007, 12:56 PM
Hi,
I have a cell B6 that may contain a maximum of 420 characters. I want the font color of every 71st character to be red.
I've tried something like this:
Range(Mid("B6"), 71, 1).Font.ColorIndex = 3
but of course this doesn't work.
how can i code this properly?
thanks
zach
I have a cell B6 that may contain a maximum of 420 characters. I want the font color of every 71st character to be red.
I've tried something like this:
Range(Mid("B6"), 71, 1).Font.ColorIndex = 3
but of course this doesn't work.
how can i code this properly?
thanks
zach