SOLVED

Highlight Dates with the help of Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2358482%22%20slang%3D%22en-US%22%3EHighlight%20Dates%20with%20the%20help%20of%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2358482%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3BI%20would%20like%20to%20know%20how%20to%20have%20a%20cell%20change%20colour%20as%20it%20approaches%20an%20expiry%20date%2C%20for%20example%2C%20the%20expiry%20date%20is%2023-Sep-21..from%20the%2023-Jul-21%20the%20cell%20is%20green...23-Jul-21%20to%2023-Aug-21%20it%20becomes%20yellow%20and%20then%20from%20the%2023-Aug-21%20to%20the%20expiry%20date%20of%20the%2023-Sep-21%20the%20cells%20turns%20red.%20so%2C%20as%20the%20date%20changes%20the%20cell%20colour%20changes%20with%20it.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20you%20please%20explain%20with%20example%20that%20what%20formula%20should%20i%20write%20in%20Conditional%20Formatting%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2358482%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2358516%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Dates%20with%20the%20help%20of%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2358516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20picture%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-16%20at%2009.07.50.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280927iD804D8E73A9162A5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-16%20at%2009.07.50.png%22%20alt%3D%22Screenshot%202021-05-16%20at%2009.07.50.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2358520%22%20slang%3D%22en-US%22%3ERe%3A%20Highlight%20Dates%20with%20the%20help%20of%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2358520%22%20slang%3D%22en-US%22%3EIt%20worked!%20Thank%20you%20so%20much%20sir%3Asmiling_face_with_smiling_eyes%3A%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E
Regular Contributor

Hello Everyone,

 I would like to know how to have a cell change colour as it approaches an expiry date, for example, the expiry date is 23-Sep-21..from the 23-Jul-21 the cell is green...23-Jul-21 to 23-Aug-21 it becomes yellow and then from the 23-Aug-21 to the expiry date of the 23-Sep-21 the cells turns red. so, as the date changes the cell colour changes with it.

Can you please explain with example that what formula should i write in Conditional Formatting? 

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Zan_Hanifee Perhaps like in the picture below.

 

Screenshot 2021-05-16 at 09.07.50.png

It worked! Thank you so much sir