Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2021, 05:23 AM
E.Buttimer E.Buttimer is offline Conditionally Colour/Shade Numeric Output Ranges Windows 10 Conditionally Colour/Shade Numeric Output Ranges Office 2016
Novice
Conditionally Colour/Shade Numeric Output Ranges
 
Join Date: Mar 2021
Posts: 1
E.Buttimer is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-25-2021, 02:20 PM
macropod's Avatar
macropod macropod is offline Conditionally Colour/Shade Numeric Output Ranges Windows 10 Conditionally Colour/Shade Numeric Output Ranges Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,986
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
Reply

Tags
conditional formatting, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditionally Colour/Shade Numeric Output Ranges How to shade this triangle like this ? kingston123 Drawing and Graphics 1 06-07-2019 04:53 AM
Conditionally Colour/Shade Numeric Output Ranges How to shade only one circle out of 2 circles? kingston123 Drawing and Graphics 15 09-20-2018 06:46 PM
Conditionally Colour/Shade Numeric Output Ranges 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
Conditionally Colour/Shade Numeric Output Ranges Disable Shade Editable Ranges globally NobodysPerfect Word 1 02-07-2014 08:34 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft