+ Reply to Thread
Results 1 to 9 of 9

Conditional formating two colour

  1. #1
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Question Conditional formating two colour

    Dear Master all,


    I want to use a conditional formatting formula with 2 colors and for a blank table it matches the color of the table style and the results I want are in column F. Please help and I want the formula without the help column.

    Thanks you

    Roykana
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,095

    Re: Conditional formating two colour

    Not following this. Why are the colors either gray or green? I thought you were referencing the banding of the table in A, but F15:F17 does not follow that logic.

    More description please!

    Edit: The pattern I see is Odd and Even. Is this what you are after?
    Last edited by jeffreybrown; 01-20-2020 at 11:41 AM.
    HTH
    Regards, Jeff

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,151

    Re: Conditional formating two colour

    How about for grey use
    =AND($A3<>"",MOD(SUMPRODUCT(--($A$2:$A2<>$A$3:$A3)),2)=0)
    and for green use
    =AND($A3<>"",MOD(SUMPRODUCT(--($A$2:$A2<>$A$3:$A3)),2)=1)

  4. #4
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Conditional formating two colour

    Dear sir


    I use according to your formula but something is wrong not to follow the color before


    Thanks you
    Roykana
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Conditional formating two colour

    Re: Conditional formating two colour
    Dear sir


    I use according to your formula but something is wrong not to follow the color before


    Thanks you
    Roykana
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Conditional formating two colour

    So in column F is the result that I want. So, I chose a different color from the number from this pnm column if the pnm number repeats it then takes the previous color and then the new number then the color is different from the previous row.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,151

    Re: Conditional formating two colour

    Please explain why the two rows flagged as wrong, are wrong.
    The fill colour changes on every value in col A which is what you have shown in col F.

  8. #8
    Registered User
    Join Date
    03-11-2018
    Location
    Bandung, Indonesia
    MS-Off Ver
    2010
    Posts
    48

    Re: Conditional formating two colour

    Okay I explain :

    PNM ROW COLOUR REMARK
    GSSI11910002 A4 GREEN
    GSSI11910003 A5 GREY
    GSSI11910002 A27 GREY previous follow results so the results should be green
    GSSI11910003 A28 GREEN previous follow results so the results should be grey

  9. #9
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    10,151

    Re: Conditional formating two colour

    If you want the row colour to change on each change in value unless that value appears earlier in the list, then I cannot help any further as I don't know how to do that.

+ 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. Conditional Formating, colour scales
    By Martinb86 in forum Excel General
    Replies: 1
    Last Post: 02-15-2017, 03:54 AM
  2. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  3. [SOLVED] to change shape colour by conditional formating/ VBA
    By asmi in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-08-2013, 03:57 AM
  4. [SOLVED] Conditional Formating and Colour filtering
    By Vibro in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2013, 02:00 AM
  5. Replies: 12
    Last Post: 02-27-2011, 05:53 PM
  6. Conditional Formating-change colour
    By vandanavai in forum Excel General
    Replies: 1
    Last Post: 01-26-2007, 05:24 AM
  7. Conditional formating-change colour when D30 is equal
    By smith.james0 in forum Excel General
    Replies: 2
    Last Post: 07-26-2005, 01:05 PM

Tags for this Thread

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