glitch with file

%3CLINGO-SUB%20id%3D%22lingo-sub-2176165%22%20slang%3D%22en-US%22%3Eglitch%20with%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2176165%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20maintenance%20file.%26nbsp%3B%20It%20works%20on%20a%20monthly%20basis.%26nbsp%3B%20All%20rows%20have%20exactly%20the%20same%20formulas.%26nbsp%3B%20They%20are%20copied.%26nbsp%3B%20All%20that%20changes%20is%20a%20date%20where%20the%20last%20maintenance%20was%20completed%20and%20and%20a%20location%20to%20determine%20which%20months%20I%20want%20the%20maintenance%20to%20be%20done.%26nbsp%3B%20I%20use%20conditional%20formatting%20to%20color%20code%20work%20completed%2C%20work%20to%20be%20done%20and%20work%20past%20due.%26nbsp%3B%20In%20row%204%20everything%20color%20codes%20properly.%26nbsp%3B%20In%20row%206%20everything%20is%20identical%20(I%20even%20recopied%20the%20formulas)%20and%20it%20doesn't%20color%20code%20the%20same.%26nbsp%3B%20I%20am%20at%20a%20loss.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2176165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2176802%22%20slang%3D%22en-US%22%3ERe%3A%20glitch%20with%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2176802%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F982751%22%20target%3D%22_blank%22%3E%40lwl101%3C%2FA%3E%26nbsp%3BThe%20formulae%20in%20columns%20V%20to%20BE%20made%20no%20sense.%20I%20tried%20to%20re-create%20them%20with%20what%20I%20think%20you%20were%20trying%20to%20do.%3C%2FP%3E%3CP%3ESee%20if%20this%20works%20for%20you.%20Revised%20file%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.