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