Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2020, 01:19 AM
Infiltrado Infiltrado is offline Shading cells with Mail Merge Windows 10 Shading cells with Mail Merge Office 2019
Novice
Shading cells with Mail Merge
 
Join Date: Feb 2020
Posts: 2
Infiltrado is on a distinguished road
Default Shading cells with Mail Merge

Hi all,

This is my first post, I decided to write a question after looking for the solution in the forums and following the instructions provided by macropod here.

I'm incapable of shading a cell (I use instructions in paragraph "Conditionally Shade Table Cells" from the previous link).

I attached three files: "Fieldcodes.png" with the code inside the cell (tab to the right, margins to 0), "Fieldcodes2.png" with the cell expanded so you can see the characters used (tab, line break...) and "Finalresult.png" that shows the outcome.

Other issue is that the cell has its height increased due to the quantity of code involved, how can I reduce the height to just the size of the final number shown?

I use Windows 10 and Office 365.

Thanks a lot. Regards.
Attached Images
File Type: png Finalresult.PNG (2.4 KB, 4 views)
File Type: png Fieldcodes.PNG (15.1 KB, 4 views)
File Type: png Fieldcodes2.PNG (12.2 KB, 4 views)
Reply With Quote
  #2  
Old 02-13-2020, 04:00 AM
macropod's Avatar
macropod macropod is offline Shading cells with Mail Merge Windows 7 64bit Shading cells with Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,918
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

The instructions in the link say to highlight the 'I' in each 'IF' with the relevant highlight colour. Instead, you've simply applied a text colour to them.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-13-2020, 04:25 AM
Infiltrado Infiltrado is offline Shading cells with Mail Merge Windows 10 Shading cells with Mail Merge Office 2019
Novice
Shading cells with Mail Merge
 
Join Date: Feb 2020
Posts: 2
Infiltrado is on a distinguished road
Default



Thank you so much! It was so easy and I did't realize that.

I discovered also how to change the size of the cells, deactivating the field codes (ALT+F9) and then adjusting the size.

Best regards!
Reply With Quote
Reply

Tags
cell color, mail merge help

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shading cells with Mail Merge Use only blue cells in database in mail merge coopfab Mail Merge 2 10-02-2019 06:18 AM
Macro to loop through all cells in a table produced by a mail merge elh52 Word VBA 4 08-31-2014 10:50 PM
Merging and Shading Cells based on Dates stockers Excel Programming 0 03-07-2013 02:32 PM
Shading in Cells in Word Tables Cindy Word Tables 1 01-04-2013 02:38 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM


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


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