Hello, I have 3 cells merged into one and inserted a dropdown menu. I have applied conditional formatting to change the fill color when an item is selected from the dropdown. However, when the color changes, it leaves a portion of the merged cell unchanged. Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting for Fill Color on Merged Cells
- Thread starter stfchr
- Start date
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
