SOLVED

Flagging columns in Excel using date

%3CLINGO-SUB%20id%3D%22lingo-sub-1232183%22%20slang%3D%22en-US%22%3EFlagging%20columns%20in%20Excel%20using%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1232183%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Excel%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20an%20issue%20with%20a%20spreadsheet%20I%20am%20creating%20and%20am%20hoping%20someone%20can%20help!%26nbsp%3B%20I%20have%20attached%20an%20example%20of%20what%20my%20spreadsheet%20looks%20like.%26nbsp%3B%20I%20need%20the%20date%20in%20each%20quarter%20to%20turn%20orange%20two%20weeks%20before%20the%20date%2C%20red%20two%20weeks%20after%20the%20date%20and%20if%20I%20enter%20a%20%22C%22%20in%20the%20column%20(for%20complete)%20then%20the%26nbsp%3Bcell%20turns%20green%20-%20this%20is%20the%20only%20part%20I%20have%20managed%20to%20master!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1232183%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1232263%22%20slang%3D%22en-US%22%3ERe%3A%20Flagging%20columns%20in%20Excel%20using%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1232263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F584103%22%20target%3D%22_blank%22%3E%40JulesMary72%3C%2FA%3E%26nbsp%3BA%20set%20of%20three%20custom%20conditional%20formatting%20rules%20can%20do%20this.%26nbsp%3B%20I%20didn't%20totally%20follow%20where%20you%20were%20putting%20the%20%22C%22%20but%20I%20have%20made%20a%20mockup%20in%20the%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1256225%22%20slang%3D%22en-US%22%3ERe%3A%20Flagging%20columns%20in%20Excel%20using%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1256225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544433%22%20target%3D%22_blank%22%3E%40Savia%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20the%20response%2C%20I%20really%20appreciate%20it.%26nbsp%3B%20Apologies%20for%20the%20delay%20in%20answering%20but%20the%20world%20has%20gone%20mad%20since%20I%20asked%20the%20question!%26nbsp%3B%20I%20will%20give%20your%20suggestions%20a%20go%20this%20week%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Excel community,

 

I am having an issue with a spreadsheet I am creating and am hoping someone can help!  I have attached an example of what my spreadsheet looks like.  I need the date in each quarter to turn orange two weeks before the date, red two weeks after the date and if I enter a "C" in the column (for complete) then the cell turns green - this is the only part I have managed to master!

 

Thanks in advance! 

2 Replies
Highlighted
Best Response confirmed by JulesMary72 (New Contributor)
Solution

@JulesMary72 A set of three custom conditional formatting rules can do this.  I didn't totally follow where you were putting the "C" but I have made a mockup in the attached.

Highlighted

@Savia Thank you so much for the response, I really appreciate it.  Apologies for the delay in answering but the world has gone mad since I asked the question!  I will give your suggestions a go this week