UDFs cannot change their environment.
So this will not work from a formula.

NickHK

"Nik" wrote in message
ups.com...
Hi,

Is there some way I can modify cell properties from a formula context?
I have a formula that takes a range as a parameter in in that formula
I call another sub that is supposed to change font color on the cells
in that range but for some reason nothing happens.