Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to fill only half part of cell in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-01-2012
Member
 
Join Date: Jan 2012
Posts: 21
How to fill only half part of cell in Microsoft Excel

I am trying to fill only half of a cell if I use a border that cuts the cell in half. Is this even possible. My goal is - one cell equals a full hour. I want a 1/2 cell to equal 1/2 hour. Any thoughts.

Reply With Quote
  #2  
Old 28-01-2012
Member
 
Join Date: Jul 2011
Posts: 432
Re: How to fill only half part of cell in Microsoft Excel

This is not possible but why not one cell=1/2 hour, two cells - 1 hour? If you have headers for the hours or similar, you can highlight two cells and Format > Cells > Alignment > Center across selection.
Reply With Quote
  #3  
Old 28-01-2012
Member
 
Join Date: Jul 2011
Posts: 432
Re: How to fill only half part of cell in Microsoft Excel

You mean you want to fill the cell with color--or you want to fill the cell with a string. You can't have multiple fill colors in that cell. You could put a rectangle over half the cell and color that, though. But why not make each cell 30 minutes.
Reply With Quote
  #4  
Old 28-01-2012
Member
 
Join Date: Aug 2011
Posts: 459
Re: How to fill only half part of cell in Microsoft Excel

It would be easier to use 2 cells side by side (eg. c4 and d4) and use conditional formatting. By setting the format of the first to be filled by a colour if it (or relevant cell) is equal to 0.5 or 30min or less, and the second cell to fill is equal to 1 or 60 min or less then you should achieve your desired effect.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to fill only half part of cell in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Excel is only printing half page in Microsoft Excel (Cowherd) MS Office Support 2 17-02-2012 04:31 PM
How to fill color in to the Row of Microsoft Excel Shaina Na MS Office Support 6 14-01-2012 01:29 PM
How to Add Cell Fill in Excel peterjack Windows Software 1 09-02-2011 02:21 AM
What is Fill Handle in Microsoft Excel Chandranath Windows Software 3 25-06-2009 07:53 PM
Excel 2000 - Change Default Cell Fill Color Cris Han MS Office Support 2 20-02-2008 09:29 PM


All times are GMT +5.5. The time now is 10:38 AM.