Conditional formatting
 

I have formatted cells with a date entered in them have custom format of
'dddd' this will give the day of the week, no problem.

The difficulty I hace now is that I want 'Saturday' and 'Sunday' to have
conditional formatting so the cells change colour. I can not seem to get this
to work with either cell = Saturday or formula = Saturday.

Please help! Am I doing something wrong or is there another way to get this
to work?

Many Thanks

Assumng A1 for the cell, try a conditional format of Formula

=weekday(A1,3)3





Patrick Wrote:
I have formatted cells with a date entered in them have custom format
of
'dddd' this will give the day of the week, no problem.

The difficulty I hace now is that I want 'Saturday' and 'Sunday' to
have
conditional formatting so the cells change colour. I can not seem to
get this
to work with either cell = Saturday or formula = Saturday.

Please help! Am I doing something wrong or is there another way to get
this
to work?

Many Thanks


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=473728

Apply formula (say A1 is the first cell in the range to be formatted)
=WEEKDAY(A1,2)5
if you number days of the week starting with Monday, or
=WEEKDAY(A1,1)=1 or WEEKDAY(A1,1)=6
if you number days of the week starting with Sunday

Regards,
Stefi

€žPatrick€� ezt Ã*rta:

I have formatted cells with a date entered in them have custom format of
'dddd' this will give the day of the week, no problem.

The difficulty I hace now is that I want 'Saturday' and 'Sunday' to have
conditional formatting so the cells change colour. I can not seem to get this
to work with either cell = Saturday or formula = Saturday.

Please help! Am I doing something wrong or is there another way to get this
to work?

Many Thanks