Hi Mynda, Appreciate your advice, the bands are variable unfortunately so I will need to add the dates as you suggest - good to know that is the so...
Steve/Anders, Thank you both very much. Steve for some reason I was not able to get your formula to work but that could just be me! Anders, you...
Thanks Anders, I apologize for my request being a bit confusing, I guess I was hoping there might be an "easier" way to get the effect I am after w...
Hi there, I did say I would post again if I was struggling and I am 🙂 In the attached file you will see that I am trying to generate a gantt ...
SunnyKow/Anders, Many thanks for the help - that's a good start for me. I am going to try an incorporate some "If's" into the formula. Will let y...
Hi Velouria, Sorry about that - I changed the formula replacing the #REF errors with the cell references and it worked! Sample attached, many than...
Hi Velouria, Many thanks for helping me out here. I added your formula but have done something wrong I guess as I can't get it working, without th...
Many thanks for taking the time to consider the requirement Mynda, sometimes its just as important to know something can't be (easily), done. I'll wo...
Hi Mynda/Sunny, Thank you both for your help. Sunny the macro worked a treat, thanks for that. Mynda, I apologize for the lack of clarity in my d...
Hi there, thanks for pointing that out! I have added it now I hope - would appreciate any advice you can give me. Alan