VBA: fill cell with colors in another workbook
Results 1 to 2 of 2

Thread: VBA: fill cell with colors in another workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA: fill cell with colors in another workbook

    Hello there,

    In workbook1 I have the following:

    ...................Name 1.......Name 2
    2019-04-16
    2019-04-17
    2019-04-18
    2019-04-19
    2019-04-20
    2019-04-21
    2019-04-22

    In workbook2, I have data as such:

    Name 1...........Activity 1.........Activity 2
    Start: ............2019-04-16......2019-04-19
    End: ..............2019-04-18......2019-04-25

    Absences:
    2019-04-19
    2019-04-21

    Is there a way to fill the cells in workbook1 based on the data in workbook2? So for cells B2:B4, it woud be filled as yellow (activity 1), cell B5 would be purple (absent), cell B6 would be blue (activity 2), B7 would be purple (absent), B8 would be blue again (activity 2).

    Thank you in advance!
    Last edited by JennV; Jun 7th, 2019 at 10:48 AM.

  2. #2
    Board Regular
    Join Date
    Nov 2013
    Location
    Denver, Colorado - XFD1048576 - MORE Stuff here near the end. And what if you add even more stuff a
    Posts
    617
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA: fill cell with colors in another workbook

    Hi JennV - Welcome to the forum. I tried to use conditional formatting across two different workbooks and received the message: "You may not use references to other workbooks for Conditional Formatting criteria." If you explain a little further what exactly you are trying to do someone may have a creative way to accomplish your task, which, on the surface seems doable. Hope this helps.
    Happy Excelling ,

    goesr

    To enter code in your post use the format below. Click the link for more detail.
    [CODE] ... Your Code Here ... [/CODE]

Some videos you may like

User Tag List

Tags for this Thread

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
  •