Results 1 to 4 of 4

Thread: How to fill only half part of cell in Microsoft Excel

  1. #1
    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    441

    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.

  3. #3
    Join Date
    Jul 2011
    Posts
    435

    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.

  4. #4
    Join Date
    Aug 2011
    Posts
    461

    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.

Similar Threads

  1. Excel is only printing half page in Microsoft Excel
    By (Cowherd) in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 03:31 PM
  2. How to fill color in to the Row of Microsoft Excel
    By Shaina Na in forum MS Office Support
    Replies: 6
    Last Post: 14-01-2012, 12:29 PM
  3. How to Add Cell Fill in Excel
    By peterjack in forum Windows Software
    Replies: 1
    Last Post: 09-02-2011, 01:21 AM
  4. What is Fill Handle in Microsoft Excel
    By Chandranath in forum Windows Software
    Replies: 3
    Last Post: 25-06-2009, 06:53 PM
  5. Excel 2000 - Change Default Cell Fill Color
    By Cris Han in forum MS Office Support
    Replies: 2
    Last Post: 20-02-2008, 08:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •