![]() |
#2
|
||||
|
||||
![]()
Cross-posted at:
Colour coding a table based on values Conditional formatting with colour in a word table - Microsoft Community For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters In the first cross-posted thread, I pointed you to the examples in 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) showing to do what you want. In this case, the field coding is as simple as: {QUOTE{=({MERGEFIELD Value}<90)*-1+({MERGEFIELD Value}>96)*1 \# "' →↵ →';' →↵ →';' →↵ →'"}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
conditional formatting, mail merge |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
kingston123 | Drawing and Graphics | 1 | 06-07-2019 04:53 AM |
![]() |
kingston123 | Drawing and Graphics | 15 | 09-20-2018 06:46 PM |
![]() |
AustinBrister | Word VBA | 19 | 08-22-2016 05:18 PM |
Way to shade editable US Map using excel | Pantucci | PowerPoint | 0 | 02-22-2016 07:05 AM |
![]() |
NobodysPerfect | Word | 1 | 02-07-2014 08:34 PM |