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.