On Sat, Sep 10, 2011 at 12:58, Rob Weir <[email protected]> wrote: > On Sat, Sep 10, 2011 at 1:35 PM, Wade Smart <[email protected]> wrote: >> I have two tabs: tab1 is my game form and tab 2 is my player roster. >> >> When I put in the team name on tab1 it populates the players from >> tab 2. >> >> This year the league mandated rosters have sequential numbering >> of players on the game forms. The captains are in bold on tab 2. >> When they appear on the game form though, that formatting does >> not carry over. >> >> How can I carry over that bold formatting from tab 2 to tab 1 with >> vlookup? >> > > Have you tried conditional formatting? If you have a column that > expresses whether the given row is a captain or not (value of 1 or 0) > then you could use conditional formatting to make the copied values be > bold or not based on that column. > > More info on conditional formatting here: > > http://openoffice.blogs.com/openoffice/2007/01/conditional_for.html > > -Rob > >> Wade >> >> -- >> -- >> Registered Linux User: #480675 >> Registered Linux Machine: #408606 >> Linux since June 2005 >> -- >> ----------------------------------------------------------------- >> To unsubscribe send email to [email protected] >> For additional commands send email to [email protected] >> with Subject: help >> > -- > ----------------------------------------------------------------- > To unsubscribe send email to [email protected] > For additional commands send email to [email protected] > with Subject: help >
Im trying to figure out how to make that work. on Tab 2 = teams. ColumnA Row 12 - 14 = number of players ColumnB Row 12 - 14 = Player Jersey Number & Player name ColumnC I put a 1 next to the captain Comumn D - > the next team Ok. On Tab 1 = Game form. H10 = I type in the Home team (ex: 1) K10 = I type in the Away team (ex: 4) K18 is my vlookup. =VLOOKUP($E18,$Teams.$A$12:$N$26,($H$10+1),0) So it looks at which team Ive put down and then gets that roster of players. So, from ColumnC above - if I insert that column, when I type in say 2 on my game form, its only going to pull a 1 because that is the captain column. Im not sure how to get around that yet. -- -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
