Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2015, 03:34 AM
haydencohen haydencohen is offline Mailmerge create a coloured box based on data Windows 7 32bit Mailmerge create a coloured box based on data Office 2010 32bit
Novice
Mailmerge create a coloured box based on data
 
Join Date: Nov 2015
Posts: 1
haydencohen is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-25-2015, 03:32 PM
macropod's Avatar
macropod macropod is offline Mailmerge create a coloured box based on data Windows 7 64bit Mailmerge create a coloured box based on data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge create a coloured box based on data 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 create a coloured box based on data Mailmerge with grouped data Keith Henderson Mail Merge 14 02-04-2015 01:45 PM
Mailmerge create a coloured box based on data 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 create a coloured box based on data Mailmerge Data Format tombradley Mail Merge 1 09-29-2013 07:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft