Link to home
Start Free TrialLog in
Avatar of Michael Vasilevsky
Michael VasilevskyFlag for United States of America

asked on

Excel 2010 Conditional Formatting Issue with Merged Cells

I'm running into a problem with conditionally formatting merged cells. See my attached example. Of course it works fine without merged cells. With '0' in each cell, the formatting is correct: 0 is displayed aligned in the center of the cell. If I put any other value however, each cell displays its value twice, in the upper and lower right corners. See attached examples if you're unable to reproduce.

Any fix or workaround for this?

User generated imageUser generated imageFormatting-Example.xlsx
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Vasilevsky


Moving everything into a new workbook solved the issue.

Thank you!