View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JICDB JICDB is offline
external usenet poster
 
Posts: 91
Default Multiple Colors in custom number format

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.