3 Attachment(s)
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:
Attachment 22572
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
1 Attachment(s)
Trying to highlight entire cell background in mail merge table
Quote:
Originally Posted by
macropod
Your attachment link is invalid. You can attach files via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
Here is the attachment.
Attachment 24087