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
>
>

Thank you for that, that's a great help.

Spike

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