View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 276
Default 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