#1
|
|||
|
|||
Mailmerge create a coloured box based on data
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 |
#2
|
||||
|
||||
Cross-posted at: http://www.mrexcel.com/forum/excel-q...ased-data.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 You might also read Conditionally Shade Table Cells in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a Bar with a slider that move based on data | jgallet | Excel | 8 | 08-21-2015 03:41 PM |
How to create a data validation based on another cell's value?? | cfreezy | Excel | 1 | 06-18-2015 09:51 AM |
Mailmerge with grouped data | Keith Henderson | Mail Merge | 14 | 02-04-2015 01:45 PM |
How to create a template with coloured bars on the side that stay where you want? | catb | Word | 3 | 09-05-2014 01:39 PM |
Mailmerge Data Format | tombradley | Mail Merge | 1 | 09-29-2013 07:35 PM |