Change font colour of digits within numbers

**NickyC** · 09-01-2011, 06:37 AM

Hi

Is there a way to change the font of a single digit within a number?

I can select single characters in text strings and change the font to red while the other characters remain black, or I can do the same with a number if I convert it to text. But when I try to change the font colour of one digit in a number it reverts to black when I press enter.

Eg

Abcdefg
1234567

**Domski** · 09-01-2011, 07:01 AM

Hi,

Not that I've come across unless it's a number that's stored as a text string.

Dom

**NickyC** · 09-01-2011, 07:23 AM

thanks Dom, I suspected as much. Seems a bit odd to have this capability only for text strings.

regards

Nicky

**Domski** · 09-01-2011, 07:26 AM

I have to admit in the years I've been on Excel forums your the first person I ever remember wanting to do that with numbers.

Dom

**NickyC** · 09-01-2011, 09:00 PM

It’s only for personal use really – I’m trying to write a macro that will show different number combinations representing ‘forcing chains’ in hard Sudoku puzzles. Not most people’s idea of fun, I’ll admit!

**Domski** · 09-02-2011, 03:10 AM

Can you not have the numbers in individual cells and colour them?

Don't do Soduko so not really sure what you're trying to achieve but would expect it would also be easier to analyse.

Dom

**abousetta** · 09-02-2011, 03:56 AM

Hi,

I have been working on something similar over the past few months and its well developed now. My purposes are a little more extensive that what you are looking for, but the concept is the same. Several of my recent threads are devoted just for issues with this topic. My most up-to-date version can be found here. Also shg has provided a very good alternative here.

I hope that you will be able to modify the code to your own needs. If you are having trouble, then post back and I will see what I can do.

abousetta

**NickyC** · 09-04-2011, 10:26 PM

Hi Domski
The cells contain several numbers representing possible values for that position. I could in theory have a different cell for each possible number, but that would mean rewriting my whole program, and increase the number of cells to manage from 81 to 700+

Abousetta
Interesting code, but again I think it only works for text strings, not for numbers

I think my solution is to temporarily convert numbers to text for the purposes of this macro, then return them to numbers once the macro completes

Cheers

Nicky