Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to highlight a column if the date in cell #4 is this week.
I used conditionaly formatting to hightlight the cell in row 4 if the date is
"this week" but now I have been asked to have the entire column (well, row 4 down) to highlight if the date is "this week". I need to use conditionaly formatting as the cells have to be used for other data. Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to highlight a column if the date in cell #4 is this week.
Is "this week" the literal text string this week or is "this week" a date
that falls within this week? If it's a date then how does this week run? From Sunday to Saturday or from Monday to Sunday (or something else)? -- Biff Microsoft Excel MVP "John R." wrote in message ... I used conditionaly formatting to hightlight the cell in row 4 if the date is "this week" but now I have been asked to have the entire column (well, row 4 down) to highlight if the date is "this week". I need to use conditionaly formatting as the cells have to be used for other data. Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to highlight a column if the date in cell #4 is this we
Sorry. "this week" is a calendar date. All the dates I will have are Monday
dates, signifying the work week a specific task is to take place. 2007's conditional formating has an option "Format only cells that contain" and then select "Dates Occurring" and "This week" that works great for the cells with the Monday date. I just can't figure out how to get the column to highlight if today is in the same week as the Monday date. If it were a month, I figured that out, but Excel doesn't have the same function for weeks (that I'm aware of). Does this answer your questions? "T. Valko" wrote: Is "this week" the literal text string this week or is "this week" a date that falls within this week? If it's a date then how does this week run? From Sunday to Saturday or from Monday to Sunday (or something else)? -- Biff Microsoft Excel MVP "John R." wrote in message ... I used conditionaly formatting to hightlight the cell in row 4 if the date is "this week" but now I have been asked to have the entire column (well, row 4 down) to highlight if the date is "this week". I need to use conditionaly formatting as the cells have to be used for other data. Thanks, . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to highlight a column if the date in cell #4 is this we
I just discovered WEEKNUM. This appears to work, I will need to copy to all
columns I want the highlighting to occur in (every other column in a series). =(WEEKNUM(W$4)=WEEKNUM(TODAY())) "T. Valko" wrote: Is "this week" the literal text string this week or is "this week" a date that falls within this week? If it's a date then how does this week run? From Sunday to Saturday or from Monday to Sunday (or something else)? -- Biff Microsoft Excel MVP "John R." wrote in message ... I used conditionaly formatting to hightlight the cell in row 4 if the date is "this week" but now I have been asked to have the entire column (well, row 4 down) to highlight if the date is "this week". I need to use conditionaly formatting as the cells have to be used for other data. Thanks, . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to highlight a column if the date in cell #4 is this we
Try one of these...
A1 = a Monday date These formulas will return either TRUE or FALSE if today's date is within the week based on the Monday date in cell A1. The week runs from Monday to Sunday. =TODAY()=MEDIAN(TODAY(),A1,A1+6) Or: =AND(TODAY()=A1,TODAY()<=A1+6) -- Biff Microsoft Excel MVP "John R." wrote in message ... Sorry. "this week" is a calendar date. All the dates I will have are Monday dates, signifying the work week a specific task is to take place. 2007's conditional formating has an option "Format only cells that contain" and then select "Dates Occurring" and "This week" that works great for the cells with the Monday date. I just can't figure out how to get the column to highlight if today is in the same week as the Monday date. If it were a month, I figured that out, but Excel doesn't have the same function for weeks (that I'm aware of). Does this answer your questions? "T. Valko" wrote: Is "this week" the literal text string this week or is "this week" a date that falls within this week? If it's a date then how does this week run? From Sunday to Saturday or from Monday to Sunday (or something else)? -- Biff Microsoft Excel MVP "John R." wrote in message ... I used conditionaly formatting to hightlight the cell in row 4 if the date is "this week" but now I have been asked to have the entire column (well, row 4 down) to highlight if the date is "this week". I need to use conditionaly formatting as the cells have to be used for other data. Thanks, . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Can Excel automatically highlight dates in the next week? | Excel Discussion (Misc queries) | |||
Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) |