Hi,

I need to create either a macro or condition formating so that i can change
a field from its defualt to green when a job is done, and back to its defualt
when deleted.

I've had a go at conditional formating and can change it to green(using a
simple macro(recorded changing the fill colour)) and can change it back to
its defualt by adding a conditional formating parameter. the problem is that
when i enter a new value into this field it automatically turns to green, and
i need it to stay as defualt until completed.

any ideas???

regards