I made a calendar in excel that grabs projects from a project data sheet, and then uses conditional formatting to color a cell if the date on the calendar is in between the start and end date of the project. Each day in the calendar is about 15 cells high so that there can be up to 15 different colored cells depicting that the certain date in the cell is during when the project is going. Everything works great, but the problem is this:
I now want to label each of the rows that are colored with the name of the project, but i cant figure out how to get the name to land on just the colored cells all the time. The dates are constantly changing and the positions of the colored cells are changing with them.
I thought that maybe if there was any way that you could use a function to create a shape that was input in a range of cells that it would work, you could just put the name in the shape, center it, and then make the fill and the border have no fill. Is something like this possible? or if not is there a better solution? If not, if anyone knows of a different program that could pull a bunch of dates from excel and make a calendar with labeled bars on it that I could use i would really appreciate it.
Thanks in advance!
I now want to label each of the rows that are colored with the name of the project, but i cant figure out how to get the name to land on just the colored cells all the time. The dates are constantly changing and the positions of the colored cells are changing with them.
I thought that maybe if there was any way that you could use a function to create a shape that was input in a range of cells that it would work, you could just put the name in the shape, center it, and then make the fill and the border have no fill. Is something like this possible? or if not is there a better solution? If not, if anyone knows of a different program that could pull a bunch of dates from excel and make a calendar with labeled bars on it that I could use i would really appreciate it.
Thanks in advance!
