I have a spreadsheet where I enter players for every team on one tab and then the next tab has those same players organized by position. I use colors to note different things about the players on one tab(like guys on the DL, guys that play multiple positions, etc.) and I can't seem to find in Excel help how to get those colors to come over to the other tab.
The formula I use to carry the player name over from the previous tab is:
='By Team'!$O$3
For some reason, I can't find what I need to add to the formula to carry over the color from one tab to the other. Anyone know? Excel help hasn't been very useful; maybe I'm not using the correct terminology.
Thanks!
The formula I use to carry the player name over from the previous tab is:
='By Team'!$O$3
For some reason, I can't find what I need to add to the formula to carry over the color from one tab to the other. Anyone know? Excel help hasn't been very useful; maybe I'm not using the correct terminology.
Thanks!