Re: vlookup question

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