Results 1 to 3 of 3

Thread: Checkbox and conditional format
Thanks Thanks: 0 Likes Likes: 0

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

    Question Checkbox and conditional format

    Hello! Once again I come to you guys in hopes of finding a solution to my problem.

    I have this sheet where it shows a list of our clients. We have about 13 offerings(products) and I want to color code them, so that when I look at client 1, I can see they show red and blue so that means they want product 1 and 2. I was trying to find a way where I could show multiple colors within one cell, but all I found was using the gradient feature and that doesnt work for me. I then thought about adding 13 narrow columns and having a checkbox represent 1 product, and may adding a conditional formatting that if that cell is checked it would turn the color assigned to that product, but again all I was able to find was correlating it to the linked cell which would be a pain because every time a client is added whoever is managing the file would have to update that and we are trying to make it very user friendly.

    Any thoughts, feedback or suggestions you may have? (VBA or anything else is welcomed)

    Hopefully this made sense. TIA!!!

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    7,963
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Checkbox and conditional format

    Why dont you just have (this sounds like what you are saying) a list of clients in column A starting at row 2
    and the 13 products in columns B-N with a header describing the products in row 1

    If you select the range B2:B10001
    and apply condtional formatting to that area checking that column A is filled then the range will stay blank until you enter a client in column A

    e.g.

    Select the range B2:B100001 (allows for up to 100000 clients)
    Use the formula

    =AND($A2<>"",B2<>"")
    format as a specific colour.

    Copy the formatting to the other columns as far as N
    Edit each of the formulas, you should only have to change the colour (I think), formula can stay the same
    format as required

  3. #3
    New Member
    Join Date
    Jun 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Checkbox and conditional format

    How could I apply this if not all 13 products would apply to the same clients? I guess that's where my issue lies. client A may not have bought the same products as client B. My goal is to be able to at a glance see what each client's needs are based on the colors (colors are assigned to a product). Thank you for your feedback!

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
  •