Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Some design ideas please

    Hello LoungersI have a project to complete and I would love to bounce some ideas and get some feedback.The application is a schedule app. and I will have the days of the week in row 1 and the names of the participants in column A.A feature that I would love to add is what if there is a situation where someone can work half a shift. Well for that I was thinking of merged cells. So if someone wanted to work half a shift the. I will unmege the cells and add them in the top or bottom cell according to what half they can work.This is easy to do in VBANow my question is can I have a triangle that I want to Color? OK what I am receding to here is something that looks like a square with a diagonal and one half say above the diagonal is colored.Is that too much work for such a simple app?Any better ideas?Thanks a million.Wassim
    Last edited by Wassim; 2012-08-04 at 11:16. Reason: sorry forgot to add version of excel used 2003
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    New Lounger
    Join Date
    Jul 2012
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can't divide a cell or pair of cells diagonally, but you could overlay a triangular shape with a high transparency factor. But I have to ask what is your objective. Having a value in one of the cell pairs tells you that it is a shift, you could fill colour that cell to make it more obvious. What extra would a triangle add?

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    I would split all days into 2 cells so you can do half shifts, then use VBA to fill in the cells using a form or dropdown.

    cheers, Paul

Posting Permissions

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