Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Dates
Help! I have a column showing installation dates being entered as mm/
dd/yy but is formatted to show the date as Monday, February 4, 2008. I want to have any cell showing "Sunday" to be highlighted in a different colour. I haven't been able to find a solution forr conditionally formatting cells that contain "Sunday" Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Dates
Select your column of date and then
Format|conditional format|formula is enter the formula =WEEKDAY(A1)=1 A1 should be the topmost cell selected. Pick a colour and click OK Mike "Chas2" wrote: Help! I have a column showing installation dates being entered as mm/ dd/yy but is formatted to show the date as Monday, February 4, 2008. I want to have any cell showing "Sunday" to be highlighted in a different colour. I haven't been able to find a solution forr conditionally formatting cells that contain "Sunday" Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Dates
On 2 Feb, 11:02, Mike H wrote:
Select your column of date and then Format|conditional format|formula is enter the formula =WEEKDAY(A1)=1 A1 should be the topmost cell selected. Pick a colour and click OK Mike "Chas2" wrote: Help! I have a column showing installation dates being entered as mm/ dd/yy but is formatted to show the date as Monday, February 4, 2008. I want to have any cell showing "Sunday" to be highlighted in a different colour. I haven't been able to find a solution forr conditionally formatting cells that contain "Sunday" Any suggestions?- Hide quoted text - - Show quoted text - Thanks Mike: That works. I changed the value in "WEEKDAY(A1)=1" to 7 to get my conditional format to work for Sunday. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Dates
Well, Chas, I'm fascinated as to how you get =WEEKDAY(A1)=7 to highlight the
Sunday dates, because for the rest of us it highlights Saturday, and it needs =WEEKDAY(A1)=1 to highlight Sundays. Perhaps you're applying =WEEKDAY(A1)=7 to cell A2, rather than to cell A1? That will muddle through if the dates are consecutive, but you'd find that your method would go all to rats if you didn't have consecutive dates. I would recommend that you format the cell based on its own content, rather than the content of the cell above. -- David Biddulph "Chas2" wrote in message ... Thanks Mike: That works. I changed the value in "WEEKDAY(A1)=1" to 7 to get my conditional format to work for Sunday. On 2 Feb, 11:02, Mike H wrote: Select your column of date and then Format|conditional format|formula is enter the formula =WEEKDAY(A1)=1 A1 should be the topmost cell selected. Pick a colour and click OK Mike "Chas2" wrote: Help! I have a column showing installation dates being entered as mm/ dd/yy but is formatted to show the date as Monday, February 4, 2008. I want to have any cell showing "Sunday" to be highlighted in a different colour. I haven't been able to find a solution forr conditionally formatting cells that contain "Sunday" Any suggestions?- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Dates
Hmmmm,
WEEKDAY(A1)=7 to highlight a Sunday!! not. Mike "Chas2" wrote: On 2 Feb, 11:02, Mike H wrote: Select your column of date and then Format|conditional format|formula is enter the formula =WEEKDAY(A1)=1 A1 should be the topmost cell selected. Pick a colour and click OK Mike "Chas2" wrote: Help! I have a column showing installation dates being entered as mm/ dd/yy but is formatted to show the date as Monday, February 4, 2008. I want to have any cell showing "Sunday" to be highlighted in a different colour. I haven't been able to find a solution forr conditionally formatting cells that contain "Sunday" Any suggestions?- Hide quoted text - - Show quoted text - Thanks Mike: That works. I changed the value in "WEEKDAY(A1)=1" to 7 to get my conditional format to work for Sunday. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Dates
On Feb 2, 1:36*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Well, Chas, I'm fascinated as to how you get =WEEKDAY(A1)=7 to highlight the Sunday dates, because for the rest of us it highlights Saturday, and it needs =WEEKDAY(A1)=1 to highlight Sundays. Perhaps you're applying =WEEKDAY(A1)=7 to cell A2, rather than to cell A1? That will muddle through if the dates are consecutive, but you'd find that your method would go all to rats if you didn't have consecutive dates. *I would recommend that you format the cell based on its own content, rather than the content of the cell above. -- David Biddulph "Chas2" wrote in message ... Thanks Mike: That works. I changed the value in "WEEKDAY(A1)=1" to 7 to get my conditional format to work for Sunday. On 2 Feb, 11:02, Mike H wrote: Select your column of date and then Format|conditional format|formula is enter the formula =WEEKDAY(A1)=1 A1 should be the topmost cell selected. Pick a colour and click OK Mike "Chas2" wrote: Help! I have a column showing installation dates being entered as mm/ dd/yy but is formatted to show the date as Monday, February 4, 2008. I want to have any cell showing "Sunday" to be highlighted in a different colour. I haven't been able to find a solution forr conditionally formatting cells that contain "Sunday" Any suggestions?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Yeah, I see the error. Got it fixed now. I was applying the formula to A2, not A1 as A1 contained my header for the column. Boy, you guys are good. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Dates | Excel Discussion (Misc queries) | |||
Conditional formatting dates | Excel Discussion (Misc queries) | |||
Conditional Formatting-dates | Excel Worksheet Functions | |||
conditional formatting dates | Excel Discussion (Misc queries) | |||
Conditional Formatting Dates | Excel Worksheet Functions |