+ Reply to Thread
Results 1 to 3 of 3

Merged cell conditional formatting with data validation not working as it should

  1. #1
    Registered User
    Join Date
    09-10-2016
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    17

    Merged cell conditional formatting with data validation not working as it should

    Hi guys im fairly new here i just want to ask why its happening or probably its a bug? Im not a native english speaker but i will do my best to explain my problem first id like you to know my excel version. Its Ms excel 365 MSO 16.0.14026.20294 64bit now let me attached screenshot which has all the explanation just incase i will have a problem explaining it

    excel-bug.png

    Ok now let me explain my problem, as you can see on the image i have made a dropdown using data validation List and if its empty it should turn red i merged 4 cells, if its just a simple merged cell no validation it works perfectly but when its a dropdown on 1st attempt not all the cell changes its background only the half of it but when i try it again or on 2nd attempt or more it serve its purpose i mean its working well only problem is on 1st attempt, is it a bug? or there is a solution?

    thank you all

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,337

    Re: Merged cell conditional formatting with data validation not working as it should

    Please update your forum profile, which tells us you are using Excel 2010.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Merged cell conditional formatting with data validation not working as it should

    I replicated your situation merging E:H and then adding a DV in these merged cells. All cells initially RED as they are blank

    When I selected a DV value the CF cleared in that cell.

    As requested above, please post a workbook.

+ 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. Replies: 3
    Last Post: 12-13-2018, 03:54 AM
  2. [SOLVED] Conditional Formatting - Two Columns for Same Date that lives in a merged cell
    By eemiller1997 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-03-2017, 05:11 PM
  3. Replies: 0
    Last Post: 09-25-2015, 02:56 PM
  4. Conditional Formatting or Data Validation for 1 cell based on another but limited data?
    By ExcelBeginner326 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2015, 01:25 PM
  5. Replies: 6
    Last Post: 06-28-2012, 11:45 AM
  6. Replies: 5
    Last Post: 05-25-2012, 02:00 PM
  7. [SOLVED] Merged Cell Conditional Formatting Borders
    By T Kirtley in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 02:45 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