A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mail Merge Conditional Formatting with Colour



 
 
Thread Tools Display Modes
  #1  
Old December 5th 16, 10:17 AM
JO GS JO GS is offline
Junior Member
 
First recorded activity by WordBanter: Dec 2016
Posts: 1
Default Mail Merge Conditional Formatting with Colour

Hi all,

I am trying to perform a mail merge into word using data from excel. The data is exam target grades and review grades which are colour coded according to progress made (red, amber, green and so on). Is there a code I can use to make the colour coding appear in the word document? The problem is is that the colours correspond to each individual's progress so I can't just use a simple code to make all A grades green for example:


Pupil Target Actual

1 A A* (conditional formatting recognises this is one above the target and so turns blue)
2 A* B (conditional formatting recognises this is two below the target and so turns red)
3 B C (conditional formatting recognises this is one below the target and so turns amber)
4 C C (conditional formatting recognises this is on the target and so turns green)

I think I need to copy the colours from excel rather than entering a condition in word - not sure if that makes sense so thank you so much in advance for your help!

Kind regards,
Jo
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merging conditional formatted cell values - especially colour buffy Mailmerge 1 April 30th 09 11:07 PM
Conditional Formatting a Mail Merge Label Steve Microsoft Word Help 2 December 9th 08 09:58 AM
CONDITIONAL FORMATTING IF/THEN STATEMENTS - MAIL MERGE pjretels Mailmerge 1 December 4th 08 07:24 PM
Word 2003 mail merge conditional numeric formatting [email protected] Mailmerge 1 September 21st 05 08:58 PM
Conditional Formatting of Margins In A Mail Merge Letter cth5c Page Layout 1 June 20th 05 10:06 AM


All times are GMT +1. The time now is 06:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.