Mar 01 2021 05:00 PM
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.
Mar 01 2021 11:23 PM
@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.