hi dave, yes i would lose the formula. the code provided by ryan and ron get
the result i need, thanks!

"Dave Peterson" wrote:

You could convert the formula to a value and do the formatting.

But you can't do this kind of formatting (manually or in code) and keep the
formula.