• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlight the cells in a row based on given days

Peter Bartholomew

Well-Known Member
It is a shame that conditional formatting is so antiquated. To use the condition within a formula one only needs a single dynamic array formula
= (start<=day)*(day<=end)
entered in cell C2. Because conditional formatting does not accept named ranges as the region to which the formatting is applied, much less dynamic ranges, nor does it apply Boolean array calculations correctly, one is reduced to relative referencing. I defined a named formula 'hightlight?' by
= (@start<=@day)*(@day<=@end)
and based the conditional formatting on that.