This type of character by character formatting won't work with formulas or with
numbers.

If you entered the data as text (preformat the cells as text or start the entry
with an apostrophe if your entries look like numbers or dates), then you can do
this kind of formatting.

JICDB wrote:

I have a project number built of separate codes which I would like to appear
in different colors so that the user will easily be able to identify the
pieces. The project number looks like this 0000-0000-0000 and I wanted the
user to be able to enter 12 numbers without the dashes and have the dashes
entered automatically.

This works fine but is there a way to make the first 4 numbers be red the
middle 4 numbers be blue and the last 4 numbers be black. Is this possible?
My users are not technically savy and anything I can do to help them would be
a benefit.

--

Dave Peterson