Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: two inputs for one cell

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am working on a spreadsheet for scheduling. For the "OFF" days I have validated the enteries using a list of initials for people. I want also to add an option for people to color code the cell to indicate: vacation, sick, personal, etc. I am stumped. Any help will be greatly appreciated. Thanks

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you only have 3 Conditions you can use Conditional formatting, otherwise you will need some VBA code.



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've tried using the conditional formatting. Already I have a list of validated entries for the cells. After the entry into the cell, I want a button to recognize the last cell selected and color it to a specific color. I will have 3 or 4 buttons each set to a distinct color.
    I've tried using "last selected cell" and "Target.Interior.ColorIndex=3". Sorry for being such a novice but I am really interested in learning how this works.

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you mean:

    ActiveCell.Interior.ColorIndex=3

    Have your button run this code.



  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you. It worked beautifully.
    Although I've run into another (I think much harder) problem. I arranged shifts into three categories: day, afternoon and night. There are three required people on each shift per day. BUT we have in place a shift rota that requires that an entry into one cell (at random) be copied to specific cells to fill the rota correctly.
    I've looked a simple solution such as A1=C3,C4,C5 but that means for each cell I have to enter a different formula. I was thinking of something along the lines of: IF(A1=text,"1","0") Then using the 1 to fill the cells assigned - then i lose the specific text. (In this case initials in a list defined by data validation.) In this way the wrong text cannot be entered so I think it would be easy to copy to the other cells in the list. But the solution eludes me still. I hope I'm not asking too simple of questions. Thanks again

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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