Conditional format sunday

[lunker55]

A1 has a date.

I want to conditional format the cell to change colour if it falls on a
sunday or saturday.
Any ideas?

Joe

 

[Domenic]

A1 has a date.

I want to conditional format the cell to change colour if it falls on a
sunday or saturday.
Any ideas?

Joe

Hi,

Try,

Format > Conditional Format > Formula Is

=or(weekday($A$1,2)=6,weekday($A$1,2)=7)

and choose your format.

Hope this helps!

 

[Peo Sjoblom]

One way

=WEEKDAY(A1,2)>5

under formula is assuming you know how to use
CF

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi
try the following
- select the cell (e.g. cell B1)
- goto 'Format - Conditional Format'
- enter the following formula
=WEEKDAY(B1,2)>=6
- choose a format

 

[AlfD]

Hi!

Have you looked at the worksheet function WORKDAYS?

Al

 

[lunker55]

Thanks guys. Works great.

Joe

Hi,

Try,

Format > Conditional Format > Formula Is

=or(weekday($A$1,2)=6,weekday($A$1,2)=7)

and choose your format.

Hope this helps!