-- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005
On Sun, Sep 13, 2015 at 12:54 AM, Brian Barker <b.m.bar...@btinternet.com> wrote: > 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 (automatically)? > > > I'm, not sure I understand your general problem, but ... > >> How do you style a element based on a range with a IF statement? > > > You may find the STYLE() function useful - something like: > =<expression>&T(STYLE(IF(condition;<style-name>;<alternative-style-name>))) > The condition is evaluated and the appropriate style name returned to the > STYLE() function, which applies that style to the cell. The STYLE() function > itself returns the value zero; to avoid this being appended inappropriately > to the result of <expression> (which is what you want to see in the cell), > the T()function is used. This returns an empty string for numerical > arguments. > > If you want the style to depend on the result of <expression> (i.e. the > value in the cell itself), you can use something like: > =<expression>&T(STYLE(IF(CURRENT()=<value>;<style-name>;<alternative-style-name>))) > > I trust this helps. > > Brian Barker > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > I messed with this for a while and just made a mess of it. I think I can do without the styling for now. Thanks -- To unsubscribe e-mail to: users+unsubscr...@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