Conditional Format a block of dates based on Start and End Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2277503%22%20slang%3D%22en-US%22%3EConditional%20Format%20a%20block%20of%20dates%20based%20on%20Start%20and%20End%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277503%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20formula%20much%20like%20the%20below%20that%20will%20shade%20cells%20according%20to%20the%20start%20and%20end%20dates%20in%20the%20table%20of%20dates.%26nbsp%3B%20I%20assume%20this%20would%20be%20in%20conditional%20formatting%20formula.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2277503%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2278701%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Format%20a%20block%20of%20dates%20based%20on%20Start%20and%20End%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278701%22%20slang%3D%22en-US%22%3EI've%20used%20your%20file%20only%20and%20applied%20the%20rules%20for%20Conditional%20formatting%2C%20and%20are%20working%2C%20please%20check%20properly%20%26amp%3B%20reapply%2C%2C%20If%20you%20are%20applying%20on%20different%20sheet%20the%20edit%20the%20cell%20references%20accordingly%20!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2278385%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Format%20a%20block%20of%20dates%20based%20on%20Start%20and%20End%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20the%20response.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20applying%20the%20logic%20to%20my%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Edo%20you%20see%20any%20reason%20why%20it%20would%20not%20work%20if%20hte%20dates%20are%20in%20a%20separate%20sheet%3F%26nbsp%3B%20I%20have%20tested%20and%20it%20doesnt%20seem%20to%20work%20as%20inidcated%20but%20your%20file%20you%20sent%20does%20work.%26nbsp%3B%20I%20have%20followed%20exactly.%26nbsp%3B%20The%20sheet%20name%20has%20no%20spaces.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elet%20me%20know....tony%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277635%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Format%20a%20block%20of%20dates%20based%20on%20Start%20and%20End%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1029845%22%20target%3D%22_blank%22%3E%40Tony2021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20the%20attached%20file%20%26amp%3B%20find%20the%20instruction%20I've%20written%20in%20red%2C%2C%20will%20help%20you%20to%20get%20the%20formula%2Fmethod.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Hello,

 

I am looking for a formula much like the below that will shade cells according to the start and end dates in the table of dates.  I assume this would be in conditional formatting formula.  

 

thank you for your help.

 

3 Replies

@Tony2021 

 

Check the attached file & find the instruction I've written in red,, will help you to get the formula/method.

@Rajesh-S 

thank you for the response.  

I am applying the logic to my file.  

do you see any reason why it would not work if hte dates are in a separate sheet?  I have tested and it doesnt seem to work as inidcated but your file you sent does work.  I have followed exactly.  The sheet name has no spaces.  

 

let me know....tony

I've used your file only and applied the rules for Conditional formatting, and are working, please check properly & reapply,, If you are applying on different sheet the edit the cell references accordingly !!