colorize celle from a range of date

S

sal21

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

colorize celle from a range of date 0
Define Certain Exact Range 2
Count number of cells containing a specific date range 7
Finding the earliest date from a range of cells 2
Fomula for number of days on each month from a date range 3

Top