Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-02-2014, 05:41 AM
bigukfan bigukfan is offline Can I Use Two Formatting Elements In The Same Field Windows 8 Can I Use Two Formatting Elements In The Same Field Office 2010 32bit
Novice
Can I Use Two Formatting Elements In The Same Field
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I Use Two Formatting Elements In The Same Field Setting formatting for field with email hyperlink JenK Excel 2 02-13-2014 10:38 PM
Can I Use Two Formatting Elements In The Same Field Merge Field Formatting Welshie82 Mail Merge 4 10-08-2012 03:38 AM
Text form field loses formatting in Word 2010 mel72349 Word 0 08-02-2011 02:25 PM
Sorting elements in a row Riccardo Excel 2 12-14-2010 10:08 AM
Can I Use Two Formatting Elements In The Same Field Text Form Field formatting problem Toshii Word 1 06-08-2009 07:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft