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
Bookmarks