glitch with file

Occasional Visitor

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.

1 Reply

@lwl101 The formulae in columns V to BE made no sense. I tried to re-create them with what I think you were trying to do.

See if this works for you. Revised file attached.