+ Reply to Thread
Results 1 to 7 of 7

Color Cells Automatically based on Value in Specific Column

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Color Cells Automatically based on Value in Specific Column

    Hi all

    I have a list I need to create daily.
    I am sorting each the data by column B
    Then, after each change in B I insert two lines
    After that each block is colored with a pre-defined color. (Range A to P)
    The place for the values can vary - so the value "ABC" could be in cell B10 today, but in B279 tomorrow.


    I'd like to automise the coloring process (and possibly the inserting rows part as well)
    So far I have found this code - but the value must be in a specific row - i'd like this part to be flexible.

    Please Login or Register  to view this content.


    Note: Empty cells in column B should result in a "No Fill" for the entire line.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Color Cells Automatically based on Value in Specific Column

    hi FallingDown, can you post sample workbook with original data and result you need to obtain?

  3. #3
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Color Cells Automatically based on Value in Specific Column

    Hi all

    I had to simply the file, as it contains sensitive data.
    But basicly this is what I need - based on the item in "A" the entire row (From A to T) should be filled in a specific, predefined color. (each item has it's color)

    Note that I have one file per day, and that this it's purly for the sake of simplicity that I have multiple days in the same file attached
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Color Cells Automatically based on Value in Specific Column

    can you add a sheet with original data as well and add explanation for coloring (what color and when)? How many colors in total are used?

  5. #5
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Color Cells Automatically based on Value in Specific Column

    Hi Watersev

    Can you tell me what you need the original file for?
    It's the same structure as I the file I have attached - just more columns and one file per day! -

    I'll use a lot of different colors, probably I'll need more then 200 (allthough it might be possible to use the same color for different items)


    So - to summarize:
    Each time the value in any row in column A is
    - A: FIll the cells of the row the value is entered in with Yellow (Range A:T)
    - B: FIll the cells of the row the value is entered in with Red (Range A:T)
    - C: FIll the cells of the row the value is entered in with Green (Range A:T)
    - D: FIll the cells of the row the value is entered in with Blue (Range A:T)
    - E: FIll the cells of the row the value is entered in with Brown (Range A:T)
    ...
    ...
    ...

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Color Cells Automatically based on Value in Specific Column

    run code "test"
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Re: Color Cells Automatically based on Value in Specific Column

    All

    I am a step closer to solving my problem:

    I have managed to make the target cell flexible.

    Please Login or Register  to view this content.
    But with this code only the target cell is colored.
    Can someone help me to change the code, so that it highlights the row from column A:T

    Contrary to the above, the target cell for the lookup is in column B

    Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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