Results 1 to 20 of 28

Thread: Mail Merge - Conditional formatting of cell background color

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #23
    VBAX Newbie
    Joined
    Sep 2020
    Posts
    1
    Location

    Mail Merge Conditional Formatting Cell Background Coloud

    Hi All,

    I followed the instructions above and use this as a reference:

    {IF{MERGEFIELD Condition}= "HIGH" "→→↵
    →→↵
    →→" \* Charformat}{IF{MERGEFIELD Condition}= "MID" "→→↵
    →→↵
    →→" \* Charformat}{IF{MERGEFIELD Condition}= "LOW" "→→↵
    →→↵
    →→" \* Charformat}

    I've set the margins (all sides) to 0, the tab is set to cell width, it's right-aligned, I use TAB (ctrl-TAB) because it's inside the cell, and for RETURN (shift-enter).but all I got is "Unknown Switch Argument". Please help

    Here's a screenshot of current work. I highlighted them to show the tabs.

    mailmerge cell colour.jpg
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •