wrote
WOW I really enjoyed the learning this

Glad that you enjoyed it, too.

if my master sheet color coded, how do I
get the color to transfer over to the child sheets?

If the color coding on the master/parent is via conditional formatting
criteria, you could simply replicate that CF on the child sheets. If it's
not, then it's not possible as formulas do not return formatting. You would
need vba. You could try posting in excel.programming for ideas.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---