Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The person who used to create our spreadsheets has left the office, and I've
been tasked with trying to recreate what she used to do with seeming ease. I'm trying to create a calender for our projects, with a series of dates (the first date of each week) in adjacent cells horizontally, all grouped within a scroll-bar. Move importantly, I'm trying to create a vertical red bar that autonmatically advances left to right as each week passes. Thanks in advance to anyone who can help us. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
More importantly, I'm trying to create a vertical red bar that
automatically advances left to right as each week passes. Try Conditional Formatting. Assuming real dates (1st-of-week chrono dates) are listed in B2 across to say E2, you could select B3:E3, then apply CF using Formula Is: =AND(ISNUMBER(B2),B2<TODAY()) Format with red fill, ok out. That should yield the progressive red bar that you seek. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Ben White" wrote: The person who used to create our spreadsheets has left the office, and I've been tasked with trying to recreate what she used to do with seeming ease. I'm trying to create a calender for our projects, with a series of dates (the first date of each week) in adjacent cells horizontally, all grouped within a scroll-bar. Move importantly, I'm trying to create a vertical red bar that autonmatically advances left to right as each week passes. Thanks in advance to anyone who can help us. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Open one of her old WBs and select the cells displaying the date bar.
Then, from the Menu Bar, click on: <Format <Conditional Format And you should see and be able to duplicate the processes / formulas she used to create the effects. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Ben White" <Ben wrote in message ... The person who used to create our spreadsheets has left the office, and I've been tasked with trying to recreate what she used to do with seeming ease. I'm trying to create a calender for our projects, with a series of dates (the first date of each week) in adjacent cells horizontally, all grouped within a scroll-bar. Move importantly, I'm trying to create a vertical red bar that autonmatically advances left to right as each week passes. Thanks in advance to anyone who can help us. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks guys, really helpful!
"RagDyeR" wrote: Open one of her old WBs and select the cells displaying the date bar. Then, from the Menu Bar, click on: <Format <Conditional Format And you should see and be able to duplicate the processes / formulas she used to create the effects. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Ben White" <Ben wrote in message ... The person who used to create our spreadsheets has left the office, and I've been tasked with trying to recreate what she used to do with seeming ease. I'm trying to create a calender for our projects, with a series of dates (the first date of each week) in adjacent cells horizontally, all grouped within a scroll-bar. Move importantly, I'm trying to create a vertical red bar that autonmatically advances left to right as each week passes. Thanks in advance to anyone who can help us. |
#5
![]() |
|||
|
|||
![]()
Recreating a Calendar for Projects in Excel
To start, let's create a list of dates for each week. You can do this by typing the first date of the week in the first cell, and then dragging the fill handle (the small square in the bottom right corner of the cell) across the adjacent cells to fill in the rest of the dates. Alternatively, you can use the Fill Series command under the Fill dropdown menu in the Editing group on the Home tab. Next, let's group these cells within a scroll bar. To do this, select all of the cells containing the dates, right-click on the selection, and choose Format Cells from the dropdown menu. In the Format Cells dialog box, click on the Alignment tab, and then check the box next to Wrap text. This will allow the dates to wrap within the cells and fit within the scroll bar. Now, let's create the vertical red bar that will advance as each week passes. To do this, we'll use a combination of conditional formatting and a formula. First, select the cell where you want the red bar to appear. Then, go to the Home tab, click on the Conditional Formatting dropdown menu in the Styles group, and choose New Rule. In the New Formatting Rule dialog box, choose Use a formula to determine which cells to format, and then enter the following formula: Formula:
Finally, let's make the red bar advance automatically. To do this, we'll use the OFFSET function in a formula. Select the cell containing the red bar, and then enter the following formula: Formula:
I hope this helps you recreate the calendar for your projects in Excel! Let me know if you have any questions or need further assistance. [/list]
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving average trend line | Charts and Charting in Excel | |||
Moving line to a column | Excel Discussion (Misc queries) | |||
HOW TO COLOR ACTIVE LINE CURSOR IS ON WHEN MOVING | Excel Discussion (Misc queries) | |||
Moving data labels around with VBA (and adding a line between two | Charts and Charting in Excel | |||
Plotting moving average line on a chart | Charts and Charting in Excel |