Custom Number Formats

[wjtmcd]

How do I create a custom format based on the first currency format so positive numbers will appear green. I know how to get there but I don't know how to type the correct format.

#[Green] -something like that?

[Corey]

You could set ALL values to GREEN fonts, and Format Cells to :

Custom-$#,##0.00;[Red]-$#,##0.00
If the value is MINUS then they will be RED.

Regards

Corey