Hello
I am making a calendar for my band, and i have an overview page then a page for each month. What i want to happen is when i enter something on the detailed page it changes the fill of the according day on the overview. With the formula's i am using it is only working for the first cell and not the rest specified in the range.
Here are my formulas
=ISTEXT(January!B5:B52) (grey fill) applies to =$C$2
=NOTISTEXT(January!B5:B52) (no fill) applies to =$C$2
2018-03-20 (1).png
2018-03-20.png
*Edit*
Working on first cell
2018-03-20 (2).png
2018-03-20 (3).png
Not working on other cells
2018-03-20 (4).png
(see comments for other photo)
Any ideas ?
Thanks
Bensley
Bookmarks