#1
|
|||
|
|||
Conditionally Shade Table Cells
Hi all, I'm trying to shade a table cell based on the value of a mail merge field. In this case, I'm simply using "R", "G" and "B" to depict whether the cell is red green or blue. I'm trying to follow the section in the sticky on this but I'm just getting coloured text. Am I misunderstanding the use for this or doing something completely wrong? I've made a single cell table, Alt+F9 to bring up the code. I'm using Ctrl+F to ender new brackets and "Insert Merge Field" to add fields. My current test code is: Code:
{IF{ MERGEFIELD Name }= "R" "*tab**tab* *tab*Test Text*tab* *tab**tab*" \* Charformat } |
#2
|
||||
|
||||
Did you try something as simple as omitting 'Test Text' and using shading instead of font colouring (as described in the Mailmerge Tips and Tricks thread)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
I thought I was following the sticky to be honest? I'm looking at the section titled "Conditionally Shade Table Cells". |
#4
|
||||
|
||||
Colouring the font and shading the range spanned by the tabs are not the same thing.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
EDIT: I've attached a couple of files to show what I'm working with, hopefully you can work out what I'm doing wrong? |
#6
|
||||
|
||||
See attached. The left column uses highlighting. The right column uses shading. Both are described on the Tips page.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Quote:
Final question.. how did you remove that final small margin on the left? I have all margins set to zero but there's still a tiny gap on the left margin. |
#8
|
||||
|
||||
By using a negative paragraph indent.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Got it! Thanks!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditionally Colour/Shade Numeric Output Ranges | E.Buttimer | Mail Merge | 1 | 03-25-2021 02:20 PM |
Conditionally Highlighting Blank Cells by Quarter in Current Calendar Year | PrincessApril | Excel | 2 | 11-29-2019 03:31 AM |
Text area in table won't shade | LSHAW | Word Tables | 1 | 03-09-2017 03:08 PM |
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B? | alshcover | Excel | 2 | 06-03-2014 12:50 PM |
How to merge two columns & replace contents of cells conditionally? | mag | Excel | 3 | 10-24-2012 01:07 PM |