Conditional format sunday

L

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
 
D

Domenic

lunker55 said:
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
Click to expand...

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!
 
P

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
 
F

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
 
L

lunker55

Thanks guys. Works great.

Joe

Domenic said:
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!
Click to expand...
 
Top