Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Excel Problem
Hi, As you can see from the enclosed image, I have a list of dates in a column, the top date is always today's date, regardless of when the spreadsheet is opened, which I arranged by using the TODAY() function, and the other dates are today's date plus 1, plus 2, plus 3, etc. Therefore the dates are moving up the list, day by day. The Saturdays are linked to the correct dates using the IF(WEEKDAY(F4)=7,"Saturday", "") function, and so on, so they are moving up the table, too. I want the boxes that seperate the weeks to move up with the dates, so that there is always a line between the Fridays and Saturdays. The ordinary Format / Border function will not do, as then the borders are fixed. I want the horizantal lines to move up the table, day by day. Is this possible? Any help would be much appreciated Thanks Spike +-------------------------------------------------------------------+ |Filename: dates.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4055 | +-------------------------------------------------------------------+ -- SpikeUK ------------------------------------------------------------------------ SpikeUK's Profile: http://www.excelforum.com/member.php...o&userid=28997 View this thread: http://www.excelforum.com/showthread...hreadid=487264 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Excel Problem
Use conditional formatting. Click in the first date cell (assumed to be a2
in the following example) then Format Conditional Formatting. Use the drop-down and the text box to set up your condition to read 'formula is' =weekday(a2)=6. Then click to select the appropriate format with the border you want to highlight Friday (weekday 6 is Friday). Once finished with that cell, use the format painter to copy the format to the rest of your dates. "SpikeUK" wrote: Hi, As you can see from the enclosed image, I have a list of dates in a column, the top date is always today's date, regardless of when the spreadsheet is opened, which I arranged by using the TODAY() function, and the other dates are today's date plus 1, plus 2, plus 3, etc. Therefore the dates are moving up the list, day by day. The Saturdays are linked to the correct dates using the IF(WEEKDAY(F4)=7,"Saturday", "") function, and so on, so they are moving up the table, too. I want the boxes that seperate the weeks to move up with the dates, so that there is always a line between the Fridays and Saturdays. The ordinary Format / Border function will not do, as then the borders are fixed. I want the horizantal lines to move up the table, day by day. Is this possible? Any help would be much appreciated Thanks Spike +-------------------------------------------------------------------+ |Filename: dates.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4055 | +-------------------------------------------------------------------+ -- SpikeUK ------------------------------------------------------------------------ SpikeUK's Profile: http://www.excelforum.com/member.php...o&userid=28997 View this thread: http://www.excelforum.com/showthread...hreadid=487264 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Excel Problem
Thank you for that, that's a great help. Spike -- SpikeUK ------------------------------------------------------------------------ SpikeUK's Profile: http://www.excelforum.com/member.php...o&userid=28997 View this thread: http://www.excelforum.com/showthread...hreadid=487264 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difficult Excel Problem
Since your help was so useful earlier, bpeltzer, I was wondering if you can point me in the right direction a little further. I thought it would be a good idea to merge the 7 cells in each weekly box, and have each group of merged cells moving up the table with their dates. I can not see a merge option in the conditional formatting dialogue. Is it possible to do this? If so, how? I enclose an updated screenshot. thanks Spike +-------------------------------------------------------------------+ |Filename: dates.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4056 | +-------------------------------------------------------------------+ -- SpikeUK ------------------------------------------------------------------------ SpikeUK's Profile: http://www.excelforum.com/member.php...o&userid=28997 View this thread: http://www.excelforum.com/showthread...hreadid=487264 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 Installation Problem | Setting up and Configuration of Excel | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem with Excel 2003 restricting functionality | Excel Discussion (Misc queries) | |||
Excel problem with web based spreadsheets | Excel Discussion (Misc queries) | |||
Staring Excel Problem | Excel Discussion (Misc queries) |