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

Steel 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_Sinha 

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 !!