If you put b$20 in the formula instead of b20, it keeps the 20 from
increasing when autofill or copy paste is used. I think that is what
you are asking.

Len

Ian D. Weatherall wrote:
Thankyou for the suggestions, I will try certainly try them.
I have been playing alittle more today and am trying this method.

b3=if((b20/4)=15,"GOAL"," ")
b4=if((b20/4)=14,....)
b5=if((b20/4)=13.......)
b20=hours scheduled, goal is 1 unit every 4 hours, b20 will always be
divisable by 4.

I do have another question related to this new method though, can I use auto
fill to move down the column without the b20 reference not increasing.

Then set CF to look for the word goal.

Thank you again,
IAn