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