#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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! |
Tags |
cell color, mail merge help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |