Quote Originally Posted by macropod View Post
See Conditionally Format Mailmerge Output and Conditionally Shade Table Cells in the Mailmerge Tips and Tricks thread at:
https://www.msofficeforums.com/mail-...ps-tricks.html

Hi,

I have already been looking at the above post, but I'm struggling to get either to work.

I was hoping to modify this to work with my values, but I can't see how it knows the ranges?

Conditionally Colour/Shade Numeric Output Ranges
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'}}

In regards the table shading trick, I don't that will work for me as one of by colours is based on a range rather than specific value.

Sorry if i'm not getting something, I am a totally newbie, but trying to learn to solve a request.

Regards

Ed