#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 } |
|
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 |