+ Reply to Thread
Results 1 to 9 of 9

Cell Colouring help

  1. #1
    Registered User
    Join Date
    05-09-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    11

    Cell Colouring help

    Hi

    im try to do some cell combination colour based on 6 cell, when excel detect first cell with same number willl combine into green colour. is there a way to do that?

    5002.png

  2. #2
    Registered User
    Join Date
    05-29-2020
    Location
    Indiana, USA
    MS-Off Ver
    M365
    Posts
    16

    Re: Cell Colouring help

    Greetings!, hope this helps!
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Applies to =$B$7:$D$7

    Working example attached.
    Attached Files Attached Files

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    5,763

    Re: Cell Colouring help

    Quote Originally Posted by Kirkules;5340626
    [FORMULA
    Please Login or Register to view this content.[/FORMULA]
    The third factor $B7=$D7 can be removed!

  4. #4
    Registered User
    Join Date
    05-09-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    11

    Re: Cell Colouring help

    thanks for reply.

    will this code work like this way as well?

    first formula
    feeff.png


    second formula
    1ddw.png

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,656

    Re: Cell Colouring help

    Using the file attached to post #2, this as the rule for B7:

    =AND(B7<>"",$B7:B7=$B7)

    Applies to range: =$B$7:$S$48

    Make this range as big as you need.

    If you want help with the second query, attach a workbook with sample data yourself, please.
    Attached Files Attached Files
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Registered User
    Join Date
    05-09-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    11

    Re: Cell Colouring help

    Hi. AliGW

    i've successfully connect the cell colour according i want but i failed to make the second query
    2122.png
    Last edited by capcomdevil; 06-02-2020 at 01:38 PM.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,656

    Re: Cell Colouring help

    I have asked you to attach the workbook here - instructions are at the top of the page. I am not going to follow an external link - do as you have been asked, please. Thanks.

  8. #8
    Registered User
    Join Date
    05-09-2020
    Location
    Japan
    MS-Off Ver
    2016
    Posts
    11

    Re: Cell Colouring help

    Sorry AliGW.

    Here my attachment
    Attached Files Attached Files

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,656

    Re: Cell Colouring help

    I see you ignored my advice on the first problem - I suggested one rule, and you have four.

    Second problem: explain the logic to the shading.
    Last edited by AliGW; 06-02-2020 at 01:44 PM.

+ 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. Using IF statements for cell colouring
    By Arvind_Mahendran in forum Excel General
    Replies: 4
    Last Post: 07-10-2012, 04:54 AM
  2. Colouring cell if it has a specific date
    By shivams22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2010, 01:13 PM
  3. Colouring Tabs Based on a Cell Value
    By TBrooker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2009, 08:09 AM
  4. Cell Colouring Diagonally
    By certain_death in forum Excel General
    Replies: 8
    Last Post: 11-30-2006, 11:35 AM
  5. no grid lines when colouring in a cell
    By stevec in forum Excel General
    Replies: 2
    Last Post: 07-12-2006, 01:10 PM
  6. [SOLVED] Automatic cell colouring
    By Chris01623 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2006, 10:00 AM
  7. colouring a cell
    By andy617 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2006, 11:35 AM

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