Apr 18 2021 03:31 PM
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.
Apr 18 2021 10:22 PM
Check the attached file & find the instruction I've written in red,, will help you to get the formula/method.
Apr 19 2021 01:10 PM
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
Apr 19 2021 11:17 PM