Re: [libreoffice-users] Style a text value if a value is present, after a vlookup

2015-09-14 Thread Wade Smart
-- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Sun, Sep 13, 2015 at 12:54 AM, Brian Barker wrote: > At 09:12 11/09/2015 -0500, Wade Smart wrote: >> >> This fills out the team rosters: >> Sheet 1 >>

Re: [libreoffice-users] Style a text value if a value is present, after a vlookup

2015-09-12 Thread Brian Barker
At 09:12 11/09/2015 -0500, Wade Smart wrote: This fills out the team rosters: Sheet 1 G16=VLOOKUP($E16,$Teams.$A$12:$I$23,($O$13+1),0) Sheet 2 Column B2:B9 = team name Column C2:C9 = captain name What I would like to do is bold the capt name for each team. How would you go about doing this

[libreoffice-users] Style a text value if a value is present, after a vlookup

2015-09-11 Thread Wade Smart
This fills out the team rosters: Sheet 1 G16=VLOOKUP($E16,$Teams.$A$12:$I$23,($O$13+1),0) Sheet 2 Column B2:B9 = team name Column C2:C9 = captain name What I would like to do is bold the capt name for each team. How would you go about doing this (automatically)? How do you style a element based