View Single Post
 
Old 06-02-2014, 05:41 AM
bigukfan bigukfan is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Mar 2014
Location: England
Posts: 9
bigukfan is on a distinguished road
Smile Can I Use Two Formatting Elements In The Same Field

I have a mailmerge document using an Excel spreadsheet. In one field called LVMass (a number) I wish to do two things at the same time. Both can be done separately (and the examples below both work), but the question is can I combine both at the same time?

1. Format the number to two decimal places using:

\# "0.00"

2. Set to bold if outside a range:

{={MERGEFIELD LVMass}-201 \#"'{MERGEFIELD LVMass}';'{MERGEFIELD LVMass}'"}

I have tried various ways to combine these without success. Is this possible?

Thank you for any advice you can give.
Reply With Quote