#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 |
Tags |
conditional formatting, mail merge |
|
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 |