Cells in a column in half?

[Ascesis]

Is this even possible?

I have a worksheet like this:

untitled.jpg

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.

(When nothing is entered, the cell is red. When a date is entered, the cell is green. I want to add another date which will turn its cell amber)

I hope this is clear.


edit: if it's impossible, it doesn't matter. I have a fairly cool plan B

[Bernard Liengme]

Please clarify. You cannot enter two dates in one cell

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ascesis" <[email protected]> wrote in
message news:[email protected]...
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> Ascesis
> ------------------------------------------------------------------------
> Ascesis's Profile:
> http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=565947
>

[Dave Peterson]

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.

Ascesis wrote:
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> Ascesis
> ------------------------------------------------------------------------
> Ascesis's Profile: http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=565947

--

Dave Peterson

[Ascesis]

Yeah, I thought it wouldn't be possible.

Plan B should've been Plan A

Thanks.

[Ascesis]

Please clarify. You cannot enter two dates in one cell

--------------------------------------------
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ascesis" <[email protected]> wrote in
message news:[email protected]...
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> Ascesis
> ------------------------------------------------------------------------
> Ascesis's Profile:
> http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=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

[Pete_UK]

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

Ascesis wrote:
> Yeah, I thought it wouldn't be possible.
>
> Plan B should've been Plan A
>
> Thanks.
>
>
> --
> Ascesis
> ------------------------------------------------------------------------
> Ascesis's Profile: http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=565947

[Ascesis]

Yes, that's exactly what I wanted to do.


Thanks.

[Pete_UK]

So maybe you can use Plan A again.

Pete

Ascesis wrote:
> Yes, that's exactly what I wanted to do.
>
>
> Thanks.
>
>
> --
> Ascesis
>
>
> ------------------------------------------------------------------------
> Ascesis's Profile: http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=565947