How do you want excel to know that the job is completed..

1. Do you have a completion date ?
If so use ConditionalFormattingCondition1Formula Is
=A1=TODAY()

2. Do you have a status column where once the job is finished you enter
'Done' or something.
If so use ConditionalFormattingCondition1Cell Value isEqual to "Done"

If this post helps click Yes
---------------
Jacob Skaria


"Gazz_85" wrote:

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