Not possible with functions, you would need an event macro

--


Regards,


Peo Sjoblom


"enna49" wrote in message
...
Hi
Please can you help with this.
I have an if statment and when the data is returned to the Cell, I want
the
exact formatting of the data that is where it is coming from.
Thanks
Anne