I would like to be able to change the font color on worksheet 2,3,4,5, and 6 (titled GAVIN, MATANZO, SHAUB, GAYNOR and DOUGLAS, respectivley) and have it change the font color on worksheet 1 (titled MASTER). Probably not explaining it too well but my intent is for the manager of his particular unit to be able to change the font color under his tab and have the corresponding tab on the master sheet to change to that color font also. See attachment. Can anyone help?
Bookmarks