colorize celle from a range of date
 

This is a simple planninig of vacation i would want a macro assigned i
to a botton in the sheet FERIESA_FATTE that make:

click on the botton and automaticly from every line of the shee
FERIESA_FATTE, this macro colorized the 2 other sheet in base of th
month example:

36755 6500 D'AGOSTINO NICOLA

have arange 02/01 05/01 colorozie in red with a little border the shee
PRIMO_SEMESTRE range E6:H6

have arange 15/03 colorozie in red with a little border the shee
PRIMO_SEMESTRE range BZ6

have arange 14/07 16/07 colorozie in red with a little border the shee
SECONDO_SEMESTRE range Q6:S6


i hope to be clear...

Attachment filename: calendar.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=63267
--
Message posted from http://www.ExcelForum.com