Hi all,

I'm trying to do conditional formatting in a word document based on student data. I would like residuals under -1 to show up in red and everything else to show up as green.
Not sure whether it's being treated as text, but it's just not working properly

I've got the following in there.

{ IF {MERGEFIELD English_Lang_Residual1 } <-1 {MERGEFIELD English_Lang_Residual1 } {MERGEFIELD English_Lang_Residual1 } }



Can anyone help please?

If -1 is to be red and everything greater in green then
{ MERGEFIELD English_Lang_Residual1 \# "0;0" }

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thanks for this. Definite progress on where I was.

It's actually everything below -1 (so -2 and under) that should be red. How would this work?

{QUOTE{SET Val {MERGEFIELD English_Lang_Residual1}}{=Val+1 \# "{Val};{Val}"}}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]