I apoligize if this has been answered but could not find this in the forums...

I have set up some conditional formatting to highlight based on a calendar date entered to track whether someone is past due on their work, green, yellow, red. I have a blank copy that I fill out daily and then 'Save As' for the current date. This works fine on the current day I'm looking at it, but when I pull up an older copy that I saved, all the dates show as red. I know it's doing this because it's saying the date entered is way past today, the current date, so it says that date is overdue. I need the highlight colors to stay highlighted corresponding to the day I first filled out the spreadsheet.
for example; if I filled out a spreasheet on 01/15/12 and on that day all the work is caught up and the dates I have entered are at 01/15/12 so they show green. I pull up the previously saved spreadsheet on 01/30/12 and since the dates entered are for 01/15/12 it shows red, but I need it to still stay green since that's what it originally was for that day I filled it out.

sorry if this doesnt make any sense, I'm pretty much at a loss and I use conditional formatting all the time... I would like to go back into my records and see if we were behind previously on something...