SOLVED
Home

Conditional Formatting for dates

%3CLINGO-SUB%20id%3D%22lingo-sub-759548%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20for%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759548%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20to%20track%20reports.%20I%20need%20each%20cell%20to%20change%20color%20according%20to%20the%20date.%20All%20reports%20are%20due%20by%20the%20end%20of%20the%20month.%20I%20need%20cells%20to%20turn%20green%20if%20the%20date%20entered%20is%20between%201-15%20of%20each%20month%2C%20orange%2016-%2028%20and%20red%2029-30%2C%2031.%20Any%20assistance%20will%20be%20greatly%20appreciated.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-759548%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759865%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20for%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759865%22%20slang%3D%22en-US%22%3EHi%20I%20created%20the%20Conditional%20formatting%20rules%20for%20you%20in%20the%20range%20B4%3AX20%20Check%20the%20attachment%20Hope%20that%20helps%20Nabil%20Mourad%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764728%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20for%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764728%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764754%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20for%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377680%22%20target%3D%22_blank%22%3E%40zlivingston%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20problem%3C%2FP%3E%3CP%3EWould%20you%20please%20like%20and%20accept%20my%20reply%20as%20best%20response%3C%2FP%3E%3C%2FLINGO-BODY%3E
zlivingston
New Contributor

I have a worksheet to track reports. I need each cell to change color according to the date. All reports are due by the end of the month. I need cells to turn green if the date entered is between 1-15 of each month, orange 16- 28 and red 29-30, 31. Any assistance will be greatly appreciated. Thanks!

3 Replies
Solution
Hi I created the Conditional formatting rules for you in the range B4:X20 Check the attachment Hope that helps Nabil Mourad

Thank you so much! @nabilmourad 

@zlivingston 

No problem

Would you please like and accept my reply as best response

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies