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
