counting consecutive days worked

I don't know how helpful this'll be, but if all you need to know is when five consecutive days have been worked, you could simply sum the values of the given cell and the four cells above it and see if it comes to 5 (you'll most likely want to skip the first four cells in the column). By using this formula along with some conditional formatting, you should be able to highlight any 5th consecutive day worked.

I appreciate your help, but that won't work for this situation. I need to restart counting after I hit a zero or empty cell. I would like to reflect the 5th day warning on a different sheet. Thanks again for the help.

Does this solve your problem?



Regarding the message, would you like to display message in the same column so that when it shows "5" it also displays message along side or do you want it using VB?