Mailmerge create a coloured box based on data

[haydencohen]

Hi,

I'm wanting to create two sets of labels with different colours on them. The first set would be a list of students who have been placed either in group 1, 2 or 3.

Each label should have a coloured box representative of the group. i.e. 1=red, 2=blue, 3=yellow.

The second set would be for resits. There are upto 4 composite parts of an assessment. On resitting, I want each label to have a maximum of four coloured boxes dependent on which parts they need to resit.

Can you help?


Hayden

 

[Macropod]

Cross-posted at: Mailmerge create a coloured box based on data
Please read our policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html