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

--
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.barker@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+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

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+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