Conditional formatting - problem with numbers

[GailH]

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?