But how is it done automatically from a user defined excel
function?

-----Original Message-----
That is done in the cell format.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kenny" wrote in
message
...
If i am using a user defined function (VBA code)

i.e.

Function TestFunc(Input Variables etc...) As Variant

'Code here

TestFunc = "Result of Code"

End Function

How is cell formatting applied similar to the way the
excel function PMT() changes format to red if output
value
is negative.


.