Hi !
I have made calendar for year 2010. It start like this; in cell K7 i have 1.1.2010 and next row in cell F8 i have 3.1.2010 and in cell F12 is 31.1.2010. Its going for last of year 2010 like att cell Y34 is 1.12.2010 and 31.12.2010 is in AA38.
On the column A in cells A15:A28 i can put name of work what is planed.
On the column B in cells B15:B28 i can put start of day.
On the column C in cells C15:C28 i can put end of day.
I want att when i put excample days start 17.1.2010 (B15) and end of date 23.1.2010 (C15)
cells F10:L10 get backround color from A15.
And when i put B16 some start day, and C16 end of date, it made same att lookup and format calendar cells with A16 backround color.
- Regards Joksu
I have made calendar for year 2010. It start like this; in cell K7 i have 1.1.2010 and next row in cell F8 i have 3.1.2010 and in cell F12 is 31.1.2010. Its going for last of year 2010 like att cell Y34 is 1.12.2010 and 31.12.2010 is in AA38.
On the column A in cells A15:A28 i can put name of work what is planed.
On the column B in cells B15:B28 i can put start of day.
On the column C in cells C15:C28 i can put end of day.
I want att when i put excample days start 17.1.2010 (B15) and end of date 23.1.2010 (C15)
cells F10:L10 get backround color from A15.
And when i put B16 some start day, and C16 end of date, it made same att lookup and format calendar cells with A16 backround color.
- Regards Joksu