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?


--
wjtmcd
------------------------------------------------------------------------
wjtmcd's Profile: http://www.excelforum.com/member.php...o&userid=36218
View this thread: http://www.excelforum.com/showthread...hreadid=560095

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