Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Last cell in Range when range is date format default105 Excel Discussion (Misc queries) 5 July 7th 09 03:11 PM
Create a formula in a date range to locate a specific date - ecel util Excel Discussion (Misc queries) 0 February 19th 07 03:03 PM
Come selezionare solo celle con font rosso con visualbasic Ivanobrb Excel Discussion (Misc queries) 2 September 18th 06 05:58 PM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Excel Worksheet Functions 2 September 1st 05 01:59 PM
colorize row if... sal21[_5_] Excel Programming 2 January 31st 04 07:14 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"