By merging multiple cells you create a single larger cell.

Do you want the formats of each cell in the single cell to be retained?

Cannot be done.


Gord Dibben MS Excel MVP

On Thu, 21 Sep 2006 10:02:02 -0700, Pablo
wrote:

In Excel 2000, on merged cells I am using conditional formatting to apply
formatting including fill color and borders. On some cells the borders only
show on part of the merged cell. It may appears like the border is only on
the first cell of the merged cells. How do I fix?