Re-formatting with currency

[bbottom]

I have an add-in that imports currency data in a spreadsheet and it reformats cells without decimals!

Is there a way to either use conditional formatting and avoid the circular reference or use even a bit of VB?

Thanks!

 

[Andrew Poulsom]

Welcome to the Board.

Sorry, why would formatting a cell cause a circular reference? Please try to be a bit more specific.

 

[bbottom]

Thanks Andrew, I'll provide my example.

Data is refreshed using a connector and the cell value is $10.99, the formatting is also refreshed to currency 0 decimals so $10 is displayed.

Conditional formatting can be applied to format colours, etc. But I've been unsuccessful with attempts to apply conditional formulas to the same cell that requires the formatting. If the value is in A1 can I use cond.formatting to do the following? e.g dollar(A1,2) etc.

Is that more clear?

Thanks,

 

[Andrew Poulsom]

Unless you have Excel 2007 you can't change number formats with conditional formatting.

 

[bbottom]

Ok, Too bad.

Thanks for the reply, much appreciated.