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

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 on a range with a IF statement?

Wade

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted