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
Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Similar threads
- Solved
