Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi, I would like to create a spreasheet that will have the dates for each day in the current month showing from A1 to A31 with the rows with weekend dates shaded grey. How would I use conditional formatting to do this? or is there another way? Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=471728 |
#2
![]() |
|||
|
|||
![]()
Select your range (a1:A31) and with A1 the activecell:
format|Conditional formatting formula is: =WEEKDAY(A1,2)5 and give it a nice shade. Ps. I like this custom format for dates like this: mm/dd/yyyy*_dddd (Underscore represents a spacebar) DKerr wrote: Hi, I would like to create a spreasheet that will have the dates for each day in the current month showing from A1 to A31 with the rows with weekend dates shaded grey. How would I use conditional formatting to do this? or is there another way? Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=471728 -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
In conditional formatting, set the condition to "Formula Is" and use
this formula: =OR(WEEKDAY(A3)=7,WEEKDAY(A3)=1) .... where A3 is the cell with the date. The WEEKDAY function returns the date's day number within the week; above, 7 = Saturday and 1 = Sunday. You can change that if you prefer- see Help. |
#4
![]() |
|||
|
|||
![]()
I would use conditional formating
select the range you wish to format <format<conditional formating change "Cell value is" to "Formula is" formula is =or(weekday($A1)=1,Weekday(A$1)=6) and set format pattern to your wanted shade (Note sometimes I have to go back into the conditional formating screen and get rid of unwanted quote marks.) "DKerr" wrote: Hi, I would like to create a spreasheet that will have the dates for each day in the current month showing from A1 to A31 with the rows with weekend dates shaded grey. How would I use conditional formatting to do this? or is there another way? Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=471728 |
#5
![]() |
|||
|
|||
![]()
Select your rows: 1:31, making sure that A1 is the active cell.
Use conditional formatting Formula is: =IF(WEEKDAY($A1,2)=6,TRUE,FALSE) Picke the color you want it shaded "DKerr" wrote: Hi, I would like to create a spreasheet that will have the dates for each day in the current month showing from A1 to A31 with the rows with weekend dates shaded grey. How would I use conditional formatting to do this? or is there another way? Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=471728 |
#6
![]() |
|||
|
|||
![]()
Select column A, then Conditional formatting/Formula
Enter in the formula field =WEEKDAY(A1;2)5 Click Format and choose a color! Regards, Stefi €˛DKerr€¯ ezt Ć*rta: Hi, I would like to create a spreasheet that will have the dates for each day in the current month showing from A1 to A31 with the rows with weekend dates shaded grey. How would I use conditional formatting to do this? or is there another way? Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=471728 |
#7
![]() |
|||
|
|||
![]()
Hi John,
Good idea on date formatting, I skipped over yours when I saw you'd got there first (BTW, same formula), not really looking at your date format with the space fill so it is justified on both left and right sides. I'll use that with ddd instead. Well actually I'd use yyyy-mm-dd*_ddd (_ used for spacebar) I see I already copied your suggestion to my datetime page from 2001-10-20 maybe I'll remember it this time. Had to delete mine because you beat me. Anyway second chance so I did also have link for additional information on Date and Time http://www.mvps.org/dmcritchie/excel/datetime.htm and I'll even include Chip Pearson's this time, different information http://www.cpearson.com/excel/datetime.htm "Dave Peterson" wrote Ps. I like this custom format for dates like this: mm/dd/yyyy*_dddd (Underscore represents a spacebar) |
#8
![]() |
|||
|
|||
![]()
There's a lot to remember on that page!
Another one that is sometimes useful: mm/dd/yyyy<ctrl-jdddd (hit ctrl-j instead of typing <ctrl-j) set the cell for wrap text and adjust the rowheight and columnwidth manually. (autofitting won't work nicely.) David McRitchie wrote: Hi John, Good idea on date formatting, I skipped over yours when I saw you'd got there first (BTW, same formula), not really looking at your date format with the space fill so it is justified on both left and right sides. I'll use that with ddd instead. Well actually I'd use yyyy-mm-dd*_ddd (_ used for spacebar) I see I already copied your suggestion to my datetime page from 2001-10-20 maybe I'll remember it this time. Had to delete mine because you beat me. Anyway second chance so I did also have link for additional information on Date and Time http://www.mvps.org/dmcritchie/excel/datetime.htm and I'll even include Chip Pearson's this time, different information http://www.cpearson.com/excel/datetime.htm "Dave Peterson" wrote Ps. I like this custom format for dates like this: mm/dd/yyyy*_dddd (Underscore represents a spacebar) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dates and shading | New Users to Excel | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |