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

Please clarify. You cannot enter two dates in one cell

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

"Ascesis" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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

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

Bernard Liengme Wrote:
> Please clarify. You cannot enter two dates in one cell
>
> --------------------------------------------
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Ascesis" <(E-Mail Removed)> wrote
> in
> message news:(E-Mail Removed)...
> >
> > 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


--
Ascesis
------------------------------------------------------------------------
Ascesis's Profile: http://www.excelforum.com/member.php...o&userid=36801
View this thread: http://www.excelforum.com/showthread...hreadid=565947

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

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

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