Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting using weekday
Hi
I want to shade a cell if the date shown is not a weekday. I know I need to use conditional formatting, but I can't work out what formula to use. Thanks |
#2
|
|||
|
|||
It's OK, I've sorted it now.
"violasrbest" wrote: Hi I want to shade a cell if the date shown is not a weekday. I know I need to use conditional formatting, but I can't work out what formula to use. Thanks |
#3
|
|||
|
|||
?B?dmlvbGFzcmJlc3Q=?= wrote
I want to shade a cell if the date shown is not a weekday. I know I need to use conditional formatting, but I can't work out what formula to use. You say "the date", but if you have a column or row of dates, select them all and apply Formula Is: If column A =WEEKDAY($A1,2)=6 If row 1 =WEEKDAY(A$1,2)=6 Choose desired format -- David |
#4
|
|||
|
|||
Hi David (Turner),
Glad you posted the solution, even though you would not have had time to see that the original poster found his own solution. It seems to me that someone who asks a question, and then says "never mind, I found the answer" is simply not sharing. Someone might see the thread, and think I need that answer or more likely find the thread in Google and want to know the answer and it would not be there had you not answered. In fact that is one of the points mentioned in Hints for New Posters http://www.cpearson.com/excel/newposte.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "David" wrote in message ... ?B?dmlvbGFzcmJlc3Q=?= wrote I want to shade a cell if the date shown is not a weekday. I know I need to use conditional formatting, but I can't work out what formula to use. You say "the date", but if you have a column or row of dates, select them all and apply Formula Is: If column A =WEEKDAY($A1,2)=6 If row 1 =WEEKDAY(A$1,2)=6 Choose desired format -- David |
#5
|
|||
|
|||
David McRitchie wrote
Hi David (Turner), Glad you posted the solution, even though you would not have had time to see that the original poster found his own solution. It seems to me that someone who asks a question, and then says "never mind, I found the answer" is simply not sharing. Someone might see the thread, and think I need that answer or more likely find the thread in Google and want to know the answer and it would not be there had you not answered. You've described precisely how and why *I* read newsgroups when not seeking specific answers for my own projects. Thanks for the feedback. -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |