kcmast Posted August 13, 2006 Share Posted August 13, 2006 I've copied in the top 120 and huddle ranking by position to Excel. I've also adjusted the rankings to my planned draft order. On draft day, I like to set the cell color to show that a player has been drafted. Is there a way to link the two cells from multitple sheets so that by setting the cell color for Larry Johnson in the top 120 it also fills in Larry Johnson in the list of RBs? I tried defining a name on one sheet and then using that name on another; it transfers the name but not any coloring. Example Larry Johnson is in cell C2 on my top 120 (sheet1) and in H3 on Top by position (sheet 2). Thanks! Quote Link to comment Share on other sites More sharing options...
MikesVikes Posted August 13, 2006 Share Posted August 13, 2006 Instead of changing the color, couldn't you just remove the name after it's been picked? Quote Link to comment Share on other sites More sharing options...
max Posted August 13, 2006 Share Posted August 13, 2006 If I remember correctly I think Rhino's Sheet does this. Quote Link to comment Share on other sites More sharing options...
kcmast Posted August 13, 2006 Author Share Posted August 13, 2006 Instead of changing the color, couldn't you just remove the name after it's been picked? It places a 0 in the cell, but that works for me. Quote Link to comment Share on other sites More sharing options...
MrTed46 Posted August 14, 2006 Share Posted August 14, 2006 If I remember correctly I think Rhino's Sheet does this. Where can we get Rhino's sheet? Quote Link to comment Share on other sites More sharing options...
Big John Posted August 14, 2006 Share Posted August 14, 2006 Where can we get Rhino's sheet? here Quote Link to comment Share on other sites More sharing options...
The Wolf Posted August 14, 2006 Share Posted August 14, 2006 Here it is: http://forums.thehuddle.com/index.php?showtopic=160060 Quote Link to comment Share on other sites More sharing options...
The Wolf Posted August 14, 2006 Share Posted August 14, 2006 Damn you are fast, Big John. Quote Link to comment Share on other sites More sharing options...
MrTed46 Posted August 14, 2006 Share Posted August 14, 2006 Thanks guys... but you can call me a momo I did a search and found. Quote Link to comment Share on other sites More sharing options...
Avernus Posted August 14, 2006 Share Posted August 14, 2006 Thanks guys... but you can call me a momo I did a search and found. what's a momo? Quote Link to comment Share on other sites More sharing options...
The Wolf Posted August 14, 2006 Share Posted August 14, 2006 Thanks guys... but you can call me a momo I did a search and found. I can't call anyone a momo who joined the Huddle 3 years after I did and still has 4x more posts! Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted August 14, 2006 Share Posted August 14, 2006 Try conditional formating Quote Link to comment Share on other sites More sharing options...
MrTed46 Posted August 14, 2006 Share Posted August 14, 2006 what's a momo? http://www.monkeymates.com/allabout.htm Quote Link to comment Share on other sites More sharing options...
smrt Posted August 14, 2006 Share Posted August 14, 2006 Since we're uncovering codes what the heck is 4983? Quote Link to comment Share on other sites More sharing options...
smithkt Posted August 14, 2006 Share Posted August 14, 2006 Homage to a post padding thread that managed to get up to 4983 posts before it was gunned. Quote Link to comment Share on other sites More sharing options...
smrt Posted August 14, 2006 Share Posted August 14, 2006 Homage to a post padding thread that managed to get up to 4983 posts before it was gunned. Thanks Smithkt, that makes sense. Quote Link to comment Share on other sites More sharing options...
Big Country Posted August 14, 2006 Share Posted August 14, 2006 Your not going to give this sheet to big ben roth are you? Quote Link to comment Share on other sites More sharing options...
smrt Posted August 14, 2006 Share Posted August 14, 2006 (edited) Not me, I donate to enough charities as it is. Plus, I don't think I would get a tax write off if I donated to Big Ben Edited August 14, 2006 by smrt Quote Link to comment Share on other sites More sharing options...
Brewer Posted August 15, 2006 Share Posted August 15, 2006 Since we're uncovering codes what the heck is 4983? Currently one of the best BOTH leagues going. We also hold kick azz social functions and bingo on friday nights. all proceeds are going to the Puddy real hair cut fund. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.