If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Moving date line
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
|
|||
|
|||
Moving date line
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),B2TODAY()) 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. |
#4
|
|||
|
|||
Moving date line
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. |
Thread Tools | |
Display Modes | |
|
|