Thread Tools Display Modes
  #1   Report Post  
JO GS JO GS is offline
Junior Member
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,
Thread Tools
Display Modes

Posting Rules

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 11:17 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright ©2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"