In the OnFormat I have been using

if me.field > then
me.field.backcolor = 16776960
end if

but this seems to be changing all the back ground what am I doing wrong?

Thank you for your help