Ok, changing the beginning of the for loop (e.g. For i = 8) will cause your "search range" to go from C8 to the last value in column C.
In regards to having the workbook change cell colors back via vba once you've updated a cell, there's a few solutions, but to be honest, unless you're running 2010, these will probably process slowly and really aren't worth it. I'm again on a pc that doesn't have Excel, so I can't test it out, but the basic idea is you set an event that runs on calculate, check if the color of the selected cell is = yellow (e.g. 6, or red e.g. 3 - depending on what color you're using), and then from there just set it back to 0 or 1 (I forget which color is white, again just google "index color excel vba" and you'll find a chart).
Basically, you change a date (e.g. force the worksheet to calculate), the macro triggers off this event, you check if your target is colored as red or yellow, if it is, turn the entire row back to white.
Sorry this is such a sloppy explanation, but again I'm back on a PC without Excel, so I know this is all possible, but I just don't know the exact syntax off the top of my head without testing it.
Bookmarks