Closed Thread
Results 1 to 12 of 12

Malfunction of conditional formatting in merged cells

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Malfunction of conditional formatting in merged cells

    Dear Gurus,

    Please help me sort out this mystery with conditional formatting malfunction in merged cells (see the attached document). When you select various options from the drop-down lists in Column D, Excel colours the cells wierdly, leaving half of it blank or wrongly coloured. Where the cells have not been merged (Row 9), the colouring works properly. What's the problem and how can that be fixed? Thank you very much in advance!

    Agnese
    Attached Files Attached Files

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Malfunction of conditional formatting in merged cells

    Hi

    Even that i don't see something wrong in your CF, i used another way..

    Is this, works for you?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    02-07-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Malfunction of conditional formatting in merged cells

    Thanks a lot, Fotis! Not sure what you did, but it works now!

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Malfunction of conditional formatting in merged cells

    You are welcome!

    I did not change anything in the column with your CF.

    I just give you a different idea in the new column. See the rules in CF for this.

  5. #5
    Registered User
    Join Date
    11-27-2012
    Location
    Glasgow
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Malfunction of conditional formatting in merged cells

    Hi Folks.

    Just new to the forum and wanted to say this has been a major help. Been pulling my hair out for hours with exactly the same problem.

    Thank you for finding a solution!

    Iain

  6. #6
    Registered User
    Join Date
    09-30-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    office 2007
    Posts
    1

    Wink Re: Malfunction of conditional formatting in merged cells

    Thank you SO much. I have been struggling with this and your solution worked perfectly! Thanks again!!!

  7. #7
    Registered User
    Join Date
    10-22-2015
    Location
    Malaysia
    MS-Off Ver
    Microsoft Excel 2013 (15.0.4701.1001)
    Posts
    1

    Thumbs up Re: Malfunction of conditional formatting in merged cells

    Thanks! My problem solved too!

  8. #8
    Registered User
    Join Date
    02-17-2021
    Location
    Olympia, Washington
    MS-Off Ver
    365
    Posts
    1

    Re: Malfunction of conditional formatting in merged cells

    Thanks! This Helped me too !

  9. #9
    Registered User
    Join Date
    07-14-2005
    Posts
    2

    Re: Malfunction of conditional formatting in merged cells

    can someone post what was changed here? I have this problem as well but cannot access/download the files attached to see the fix.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Malfunction of conditional formatting in merged cells

    I just opened the file with no problems?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Registered User
    Join Date
    03-31-2014
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20220) 64-bit
    Posts
    5

    Re: Malfunction of conditional formatting in merged cells

    I've downloaded both files but can't see what was changed? I can see the column where the CF works properly but can see no difference in how it's set up compared to the one that doesn't work? Can you help please? Thanks

  12. #12
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    Re: Malfunction of conditional formatting in merged cells

    Hi.

    It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


    The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.

    ALSO>>>>>

    Hi. Before we get going on this one...

    Is your forum profile showing the Excel PRODUCT that you need this request to work with?

    The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

    The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

    Cheers,

    Glenn.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

Closed 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