Forum Discussion
Calendar where values link depending on the date above. Values save to this date but I can edit also
I have created a dynamic calendar where the dates change specific to the month and year selected. I would like to know how I can format the cells bellow the corresponding date number so that they are linked and change when I select a new month or year.
3 Replies
Conditional formatting shall work, but It depends what are using as days, month and year. They are dates formatted as "dd", "mmmm" and "yyyy" or so, or texts, or mix.
Thank you for your response. Here are some of the formulas I am using to have the dates change dynamically. What I am trying to do now is link the cells underneath the day number, so that when they change, the text i enter into them will change again.
It looks like you have actual dates in cells like B6. If so you may apply Conditional Formatting with rule formula like
=(B6<start)+(B6>=EOMONTH(start,0) )for grey format and applying it to B6:H6. After that with format painter to other date ranges.
