Custom Number Formats
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 |
Custom Number Formats
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 |
All times are GMT +1. The time now is 07:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com