Is this even possible?
I have a worksheet like this:
5120
From A2 down are just names.
Now, I want to enter two dates for each cell in red. I'm asking if
splitting cells in half is possible, because I want to add different
conditional formatting (different colour!) to each date.
+-------------------------------------------------------------------+
|Filename: untitled.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5120 |
+-------------------------------------------------------------------+

Signature
Ascesis
Bernard Liengme - 28 Jul 2006 12:46 GMT
Please clarify. You cannot enter two dates in one cell

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> Is this even possible?
>
[quoted text clipped - 12 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=5120 |
> +-------------------------------------------------------------------+
Ascesis - 28 Jul 2006 16:18 GMT
Bernard Liengme Wrote:
> Please clarify. You cannot enter two dates in one cell
>
[quoted text clipped - 31 lines]
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=565947
Oh, what I actually meant was, the cell underneath the header for the
dates should be split in half.
-------------------------------
Like
A1 is a cell
and A2 is split in half with something like the split column function
on Word or something

Signature
Ascesis
Dave Peterson - 28 Jul 2006 13:14 GMT
I can't see your sample--I don't use excelforum.
Conditional formatting affects the whole cell.
And your life will be much easier if you keep the dates in separate cells.
> Is this even possible?
>
[quoted text clipped - 18 lines]
> Ascesis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36801
> View this thread: http://www.excelforum.com/showthread.php?threadid=565947

Signature
Dave Peterson
Ascesis - 28 Jul 2006 16:14 GMT
Yeah, I thought it wouldn't be possible.
Plan B should've been Plan A
Thanks.

Signature
Ascesis
Pete_UK - 29 Jul 2006 00:38 GMT
You can use columns A and B for your dates and for your header in A1
highlight A1:B1 then Format | Cells | Alignment (tab) and for
Horizontal Alignment choose Centre Across Selection - this will give
you the effect of a split column, particularly if you use vertical
borders, but the dates have to be in different columns.
Hope this helps.
Pete
> Yeah, I thought it wouldn't be possible.
>
[quoted text clipped - 7 lines]
> Ascesis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36801
> View this thread: http://www.excelforum.com/showthread.php?threadid=565947
Ascesis - 31 Jul 2006 09:22 GMT
Yes, that's exactly what I wanted to do.
Thanks.

Signature
Ascesis
Pete_UK - 31 Jul 2006 09:47 GMT
So maybe you can use Plan A again.
Pete
> Yes, that's exactly what I wanted to do.
>
[quoted text clipped - 6 lines]
> Ascesis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36801
> View this thread: http://www.excelforum.com/showthread.php?threadid=565947