Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |