A formula can't return the formatting from another cell. Perhaps you
could use conditional formatting or programming to colour the cells.

Midnite Thunder wrote:
I want to use color coding from a master sheet for sorted info to go to
individual members of a band. This would greatly simplify set list with notes
for each player.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html