Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2004

Tip: Looking for answers? Try searching our database.

Make merged field bold if merged field is > 3

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vick - 10 Dec 2004 20:21 GMT
if merged field > 3 then the merged field needs to be bold, otherwise it
should not be in bold.
Greg Maxey - 10 Dec 2004 20:32 GMT
Vick

Try something like:

{ IF { Test } >"3"{ Test \* Charformat }{ Test } }

Replace "Test" with your mergefield name and apply bold format to the "T"
immediate to the right of the value 3.  Look up Charformat in Word help and
you will get an explanation and other examples.

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> if merged field > 3 then the merged field needs to be bold, otherwise
> it should not be in bold.
Vick - 13 Dec 2004 14:33 GMT
The following did not work because the merged field is formatted as numeric
and needs to be tested as > 3 (or a specific number). The original merged
field appears as

{Mergefield "v1Mean"\# ##0.##}

So I am trying to format the above merged field in bold if the number
(v1Mean) is greater than 3.

Any more help greatly appreciated.

Vick

> Vick
>
[quoted text clipped - 8 lines]
> > if merged field > 3 then the merged field needs to be bold, otherwise
> > it should not be in bold.
Cindy M  -WordMVP- - 15 Dec 2004 14:32 GMT
Hi =?Utf-8?B?Vmljaw==?=,

> The following did not work because the merged field is formatted as numeric
> and needs to be tested as > 3 (or a specific number). The original merged
[quoted text clipped - 4 lines]
> So I am trying to format the above merged field in bold if the number
> (v1Mean) is greater than 3.

What Gregy showed you works when I test it with your numerical switch, and
take away the "quotes" around the 3. You also need to insert spaces between
the various parts of the equation (see below). Sometimes, Word cares whether
something is textual or numeric; but most of the time it doesn't matter.

{ IF { Test \# "##0.##" } > 3 "{ Test \# "##0.##" \* Charformat }" "{ Test \#
"##0.##" }" }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.