Custom number Formatting

[pgerardi]

Hi guys, need a little help with some number formatting. Lets say I have 2 numbers as an example: Col A = 32 Col B = 37 Col C gives the result of (5) & Col D = @column C/@Column B which results in -13.51% Is there a way to display the result as: (13.51%).

Basically I want to change the font color from black to green while maintaining the same formatting. I tried Custom 0.0%;[Green](0.0%) but it shows a lime green that you cannot read on the screen.

Thanks for your time.

 

[Fluff]

You can use the color index
0.0%;[Color 50](0.0%)
For a list of the colors see here

Color Palette and the 56 Excel ColorIndex Colors

Excel Color Index, coloring of fonts, cell interiors

dmcritchie.mvps.org

 

[pgerardi]

Perfect, that is exactly what I needed.

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[pgerardi]

Can I add a new twist to this, I guess maybe what I might need is conditional formatting. If I were to perform this calculation monthly, the next month Col A = 40 & Col B is the same then I would need the result to be displayed in red. Is this possible?

Thanks again

 

[Fluff]

As this is a totally different question, you will need to start a new thread. Thanks.

 

[pgerardi]

Ok thanks