Cells formaring with VBA ?

Joksu · Joksu's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
That document contains too many cells. At this time, spreadsheets inGoogle Docs only support up to 400000 cells	Mark	Microsoft Excel Misc	0	19th Jan 2011 03:08 PM
Excel: match two cells in one sheet to two cells in another and return a third cells value	Spence	Microsoft Excel Worksheet Functions	2	19th Jul 2005 04:19 AM
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells	Wescotte	Microsoft Excel Programming	1	6th Jun 2005 07:00 PM
trying to create an (almost) circular formula between cells and data validated cells with lists	KR	Microsoft Excel Worksheet Functions	0	12th May 2005 07:21 PM
A calculation to count all cells ='D' where the offset cells in range have dates <= todays date	AlanN	Microsoft Excel Misc	2	29th Jan 2004 03:57 PM