+ Reply to Thread
Results 1 to 3 of 3

Categories with different colors..

  1. #1
    Registered User
    Join Date
    03-03-2025
    Location
    Wilmington, NC
    MS-Off Ver
    365
    Posts
    63

    Categories with different colors..

    Hi there..

    I need some help please.. Trying to see if it is possible to have different colors for the different categories, like the 12oz stays blue, but the 16oz is maybe red and the refill like a greenish color.. And then when you go into the category, those blocks are the same color as the main.. It's just so when someone is working on the POS and they don't read the description that says whether it is 12oz or 16oz, they don't make the mistake of charging customers in the wrong category..

    Screenshot 2025-06-23 130321.png
    Screenshot 2025-06-23 130333.png
    Screenshot 2025-06-23 130342.png
    BAR POS OG (2).xlsm

    Thank you!!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,479

    Re: Categories with different colors..

    The current posted image is a PNG file and it is a single image. You'll need to break the image down into individual selections and layers to perform what you are seeking.

  3. #3
    Forum Contributor
    Join Date
    01-25-2025
    Location
    Presov, Slovakia
    MS-Off Ver
    2021
    Posts
    297

    Re: Categories with different colors..

    Hi Nielinki,
    one way is:
    - sheet "ITEMS", column "F" - color the cell in the corresponding row with the desired color,
    - sheet "ITEMS", add the word "colour" to cells "F2" and "S2",
    - the code colors the button with the color it has in "its" row,

    Code changes:
    - editing the copy range:
    Please Login or Register  to view this content.
    - new code for coloring
    Please Login or Register  to view this content.
    Celý kód v module "Load_Category":
    Please Login or Register  to view this content.
    The attached file is for illustration only - some older version.
    m.s.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Complex chart based on several categories and sub-categories
    By Demolitionben in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-04-2023, 02:01 AM
  2. [SOLVED] Need sum total of categories per interval based on agent schedules and their categories
    By cph020283 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2021, 05:21 PM
  3. Link two pivot charts such that same axis categories get same colors.
    By cudh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2014, 06:18 AM
  4. Replies: 0
    Last Post: 09-19-2014, 09:07 AM
  5. [SOLVED] Possible to Alternate Colors of Multiple Rows of Categories
    By syuzhet in forum Excel General
    Replies: 3
    Last Post: 11-01-2013, 10:07 AM
  6. Replies: 1
    Last Post: 05-15-2013, 06:55 AM
  7. Replies: 0
    Last Post: 07-22-2011, 03:51 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1