Consulting

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. #1
    VBAX Newbie
    Joined
    Jul 2018
    Posts
    2
    Location

    Mail Merge - Conditional formatting of cell background color

    I'm doing a mail merge of a list of inventory numbers with 3 mergefields to make a sheet of scan labels.

    The cells are formatted as:

    mergefields.jpg

    I'm wanting to change the background color of the cell based on the CLASS mergefield. If the value is 08 I want the background to be colored yellow, otherwise I want the cell to be the default color.

    What would be the VBA code for a macro to be able to do this?

    Attached is my sample data.

    Thanks
    Attached Files Attached Files

Posting Permissions

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