#1
|
|||
|
|||
Conditionally Colour/Shade Numeric Output Ranges
Hi
I hope someone can help me. I am using mail merge to inport values from a excel spreadsheet into a table in my word document. I ideally want the cell to change colour as in excel based on the following criteria: Merge Value >96 Green Merge Value <90 Red Merge value between 91 and 95 Amber I have found this info already but I cant see how it should work based on the figures in the example. (I know this just changes the text colour rather than the cell) You can use field coded to apply up to three colour/highlight formats to numeric data falling into various ranges. In the following examples, values up to 200 get coloured green, values over 240 get coloured red and values between these get coloured orange. {QUOTE{=INT({MERGEFIELD Val}/40)-5 \# "{MERGEFIELD Val \* Charformat } - High';'{MERGEFIELD Val \* Charformat } - Low';'{MERGEFIELD Val \* Charformat } - Medium'}} Can anyone advise Ideally I would like the cell to be highlighted in colour with the value in black. Hope someone can help, been at it two days |
#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 | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to shade this triangle like this ? | kingston123 | Drawing and Graphics | 1 | 06-07-2019 04:53 AM |
How to shade only one circle out of 2 circles? | kingston123 | Drawing and Graphics | 15 | 09-20-2018 06:46 PM |
Take String of numbers, expand ranges, sort, then compress back into ranges | 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 |
Disable Shade Editable Ranges globally | NobodysPerfect | Word | 1 | 02-07-2014 08:34 PM |