Conditional Format based on day of the week 2

[YANKRAY]

MS Excel 2003.

I have a row of dates (by day).

The day is formated to only show the day of the week:

Mon Tue Wed Thu Fri Sat Sun

Can I (how can I) conditionally format the cells that contain Sat and Sun to have a different background color (for examply gray).

Thanks,
Ray

 

[SkipVought]

Check out Format > Conditional Formatting


Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[YANKRAY]

Skip,

Thanks for the quick response. I understand where, but don't know how to write the formula.

Ray

 

[SkipVought]

In addition the MOD function, MOD(CellRef,7) either 0 or 1, for sat or sun.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[AnotherHiggins]

Formula Is: =WEEKDAY(A1,2)>5

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

[tt]
=OR(mod(a1,7)=0,mod(a1,7)=1)
[/tt]
where a1 is the FIRST date

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[AnotherHiggins]

poor ol' cat is in for some skinning today!

=Or(TEXT(A1,"ddd")="Sat",TEXT(A1,"ddd")="Sun")

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Or...
[tt]
=Left(TEXT(A1,"ddd"),1)="S"
[/tt]


Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[YANKRAY]

Thanks Skip and John.