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?

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?

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.

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 -

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.

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