Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting of Saturday/Sunday in calendar
I've got a simple calendar. I want to format the rows that refer to Saturday
and Sunday. It seems like it should be easy, but since the text is auto generated, I can't seem to used it in a formula i.e. Format Only Cells That Contain Specific Text containing Saturday I know I've done this before but it's been a while. Anybody have any bright ideas? Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting of Saturday/Sunday in calendar
Valorie,
Use the formula is option, with the formula =WEEKDAY(A1,2)5 Replace A1 with the cell address - if you are formatting entire rows based on a single column, then use the $A1 absolute reference style HTH, Bernie MS Excel MVP "Valorie" wrote in message ... I've got a simple calendar. I want to format the rows that refer to Saturday and Sunday. It seems like it should be easy, but since the text is auto generated, I can't seem to used it in a formula i.e. Format Only Cells That Contain Specific Text containing Saturday I know I've done this before but it's been a while. Anybody have any bright ideas? Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting of Saturday/Sunday in calendar
If the cells in question are actual Excel dates, then use a custom
Conditional Formatting formula of =WEEKDAY(A1)=7 Select the cells to highlight, open CF and specify "Use Function" and use the function above. Change the A1 to the first cell that is to be formatted. If the cells actually contain "Saturday" as text, not as a date, use a formula of =A1="Saturday" as the custom formula in CF. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 28 Aug 2009 07:01:01 -0700, Valorie wrote: I've got a simple calendar. I want to format the rows that refer to Saturday and Sunday. It seems like it should be easy, but since the text is auto generated, I can't seem to used it in a formula i.e. Format Only Cells That Contain Specific Text containing Saturday I know I've done this before but it's been a while. Anybody have any bright ideas? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Friday as weekend instead of Saturday & Sunday | Excel Worksheet Functions | |||
I want to set weekly off as Thursday instead of Saturday & Sunday | Excel Worksheet Functions | |||
NETWORKDAYS including Saturday and Sunday | Excel Discussion (Misc queries) | |||
Sunday to Saturday weekly foreward planner | Excel Worksheet Functions | |||
Is there a way to identify saturday and sunday automatically | Excel Discussion (Misc queries) |