I created a maintenance file. It works on a monthly basis. All rows have exactly the same formulas. They are copied. All that changes is a date where the last maintenance was completed and and a location to determine which months I want the maintenance to be done. I use conditional formatting to color code work completed, work to be done and work past due. In row 4 everything color codes properly. In row 6 everything is identical (I even recopied the formulas) and it doesn't color code the same. I am at a loss.