>* suppress zeros, format as currency, for negative numbers use () and red color >.columns("J:K").NumberFormat ="$#,##0.00_);[Red]($#,##0.00);;@" >