L
Legacy 241886
Guest
Hello,
I am new in this forum. My first question to my project is, if it is possible and if yes if someone can give me any advice how to do it.
I have a table in worksheet 1 with one column for the starting date and the next column for the ending date. In the next worksheet (worksheet2) I have a table in with every column is a new day f.e. cell A1 = 04/01/13 cell B1 = 04/02/13 C1= 04/03/13 and so on. I would like to write a macro which colors all the cells between the starting date and the ending date out of worksheet 1. So excel needs to realize the starting and ending date of worksheet one and find these dates in worksheet 2 and color every cell between these dates.
Do you think this is possible?
Thank you very much!
Dänny
I am new in this forum. My first question to my project is, if it is possible and if yes if someone can give me any advice how to do it.
I have a table in worksheet 1 with one column for the starting date and the next column for the ending date. In the next worksheet (worksheet2) I have a table in with every column is a new day f.e. cell A1 = 04/01/13 cell B1 = 04/02/13 C1= 04/03/13 and so on. I would like to write a macro which colors all the cells between the starting date and the ending date out of worksheet 1. So excel needs to realize the starting and ending date of worksheet one and find these dates in worksheet 2 and color every cell between these dates.
Do you think this is possible?
Thank you very much!
Dänny