Hi,
I have a sub form that i am applying conditional formatting to.
When a certain value is reached it turns the row red this all works fine apart from when i create a new record in the subform the pencil symbal appears next to the new record the next "pending" record that appears below that, with the asterix next to it, turns red also its only when you refresh the form it goes back to being white is there anyway of stopping the bottom row with the asterix turning red?
Thanks Phill