You could do what you propose with a macro, but a formula can only
return a result - not a format.

Hope this helps.

Pete