Using Apache POI to develop a document and i am getting a little trouble with cell styles, currentlly i am using:

CellStyle currencyCellStyle=workbook.createCellStyle();
currencyCellStyle.setDataFormat(format.getFormat("$#,##0.00"));

Which works totally acceptable for positive amounts, however I must assign another style to negative cells instantly.

Real question is can there be any to create this up without needing to look into the individual cell values and assign another style for them?

Or else can there be in whatever way to inform Apache POI to make use of the built-in stand out currency format and among its negative options?

Thought it was, thanks me :D

CellStyle currencyCellStyle=workbook.createCellStyle();
currencyCellStyle.setDataFormat(format.getFormat("$#,##0.00;[Red]($#,##0.00)"));