Autofill with changes
 

Hi. I have a spreadsheet that I'd like to program to work automatically
and am not sure how to accomplish this. I'd like to be able to enter a
new date and item in the top portion of the spreadsheet and have that
information populate the calendar with the appropriate formatting.

Example:

Item Day Date
Quote Due Wed 1/18
Preview Fri 1/20

Below in the same worksheet is a calendar where each day is the
equivalent of cells a1 and a2 merged (2 cells - 2 rows x 1 col), no
color, font size 7 with the date formatted to the bottom, right side of
the merged cell.

I'd like to be able to enter a date above (such as 1/18 for Quote Due)
and have Excel look for that date in the calendar, unmerge the two cells
of that date, place the days date in the bottom of the cell to the right
in font 7, place the "Item" listed above (Quote Due) in the top cell, in
font 8 centered and change both cells to the color light green.

Similarly, if the Quotes Due date changes to 1/25, I'd like the cell to
return to the original formatting.

Can anyone give me a hand with this?:eek:


--
lbond
------------------------------------------------------------------------
lbond's Profile: http://www.excelforum.com/member.php...o&userid=30480
View this thread: http://www.excelforum.com/showthread...hreadid=501375