Q:

Formatting numbers in excel in a 3 value currency

Me and a friend are trying to make a spreadsheet in excel that can help us with displaying numbers as the currencies used in MMO games. 
We are trying to create this spreadsheet as a help for selling and buying items in  Guild Wars 2. As currencies in the game does not use number formatting as Euro and Cents etc. But instead has a format of Gold Silver and Copper, we are trying to make a custom value format that can hold this information.
So far we have something useable but we would like to make it a bit more manageable. 
Our format is currently: #"G "##"S "##"C"
This works decently but we would like it so that G and S will not be displayed if we only have, say, 80 copper. Further, we were also wondering if it is possible for us to color code each subvalue with a different color. I know it is possible to do it so the whole value if we have a negative value, but as far as i understand it is not possible to color individual parts of the number in a cell. 
Does anyone know if this is possible to do ?

A:

You are on the right track, you can specify conditionals by using bracket []:
Example: Color numbers less than or equal to 2000 RED and numbers greater than 3000 GREEN and stuff between 2000 and 3000 BLUE would translate to:
[Red][<=2000]#,##0" Reds";[Green][>3000]#,##0" Greens";[Blue]#,##0" Blues"

You apply this custom formatting by doing Right+Click, Format Cells, and under Category choose custom and enter the above code.  The #,##0 is to comma separate the values above 1,000.  Tweak and enjoy.

