Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighted cells
This is hard to explain but i will try If i have cells B1:Z1 with the formula =weekday(B2)inB1, then =B1+1 inC1 etc, B2:Z2 with dates of the month (1/1/2006 etc) And B3:Z3 with in in in in out out in in in in out out... etc (a 4days in 2 days out work pattern) and all the out are highlighted green through conditional format. When you come to the beginning of the year 2007 the two days out should be SUN/MON (31st-1st) & then SAT/SUN (6th-7th) Is there any way of getting the in/out cells to move forward when you change the year from 2006 to 2007 Hope somebody can understand this or i can forward a sample of what i am trying to do THANKS -- Caveman ------------------------------------------------------------------------ Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546 View this thread: http://www.excelforum.com/showthread...hreadid=492817 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighted cells
You can set a field in your workbook some where for a date parameter. The
date parameter "TL_Oride" is the date you'd like the series to begin. This can be a value like 1/1/2006 or a calculated amount like =TODAY()-2 Then, have your first date cell in the series hold this formula. =IF(TL_Oride="",TODAY()-7,TL_Oride) The next field in the series would follow the +1 as you noted you are already using. "Caveman" wrote: This is hard to explain but i will try If i have cells B1:Z1 with the formula =weekday(B2)inB1, then =B1+1 inC1 etc, B2:Z2 with dates of the month (1/1/2006 etc) And B3:Z3 with in in in in out out in in in in out out... etc (a 4days in 2 days out work pattern) and all the out are highlighted green through conditional format. When you come to the beginning of the year 2007 the two days out should be SUN/MON (31st-1st) & then SAT/SUN (6th-7th) Is there any way of getting the in/out cells to move forward when you change the year from 2006 to 2007 Hope somebody can understand this or i can forward a sample of what i am trying to do THANKS -- Caveman ------------------------------------------------------------------------ Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546 View this thread: http://www.excelforum.com/showthread...hreadid=492817 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect only the highlighted cells in Excel? | Excel Discussion (Misc queries) | |||
How do I count cells that have are highlighted a certain color? | Excel Worksheet Functions | |||
Can I sum only highlighted cells in a worksheet? | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |