Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Cells in a column in half?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ascesis - 28 Jul 2006 11:53 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.