Conditional text formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chad - 28 May 2004 23:41 GMT

I'm mail merging excel data and what I want to do is conditionally format the data bold depending on the result. For instance if the data is "Bellingham" I want it to be bold, if it is "Everett" I want the data to not be bold. I'm new to mail merging so I'm unfamiliar with the "code" aspect of it.

Reply to this Message

Doug Robbins - Word MVP - 29 May 2004 01:10 GMT

Insert the following field construction:

{ IF { MERGEFIELD City } = "Bellingham" { MERGEFIELD "City" \*CHARFORMAT }
{ MERGEFIELD "City" } }

and in the { MERGEFIELD "City" \*CHARFORMAT } part of the field
construction, select the M of MERGEFIELD and apply bolt formatting to it.

You must use Ctrl+F9 to insert each pair of field delimiters { } and use
Alt+F9 to toggle off the field codes. You may need to press F9 once to get
the field to update the first time, but thereafter it should work.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I'm mail merging excel data and what I want to do is conditionally format the data bold depending on the result. For instance if the data is

"Bellingham" I want it to be bold, if it is "Everett" I want the data to not
be bold. I'm new to mail merging so I'm unfamiliar with the "code" aspect
of it.

Reply to this Message

Greg Maxey - 29 May 2004 01:21 GMT

Chad,

Try a nested conditional IF field with a \*Charformat switch:

{ IF {MERGEFIELD "Your Mergefield"} = "Bellingham"{MERGEFIELD "Your
Mergefield" \*Charformat}{MERGEFIELD "Your Mergefield"} and apply bold
formating to the "M" in the field containing the charformat swith.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> I'm mail merging excel data and what I want to do is conditionally
> format the data bold depending on the result. For instance if the
> data is "Bellingham" I want it to be bold, if it is "Everett" I want
> the data to not be bold. I'm new to mail merging so I'm unfamiliar
> with the "code" aspect of it.

Reply to this Message