try this might work
1. select your field
2. do an after update event
3. select the code "VB"
4. type in the following lines
If [fieldvalue] < 0 then
[fieldvalue].forecolor = vbred
else
[fieldvalue].forecolor = (orginal color ) vb+color or rgb(87,171,83)...