Conditional Formatting of merged cells, borders don't show correct
 

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?

Conditional Formatting of merged cells, borders don't show correct
 

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?

Conditional Formatting of merged cells, borders don't show cor
 

No, I want one conditional format to cover the entire merged cell. It has
worked in many places on the worksheet. In some places it only puts borders
around part of the merged cell. I have tried unmerging the cell and
remerging it and then placing the format formula on again with no luck.

"Gord Dibben" wrote:

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?

Conditional Formatting of merged cells, borders don't show cor
 

I cannot replicate your problem.

CF colors and borders the merged cell as I ask it to.

Maybe a video card issue?

Or a printer driver issue?

Gord

On Thu, 21 Sep 2006 11:39:01 -0700, Pablo
wrote:

No, I want one conditional format to cover the entire merged cell. It has
worked in many places on the worksheet. In some places it only puts borders
around part of the merged cell. I have tried unmerging the cell and
remerging it and then placing the format formula on again with no luck.

"Gord Dibben" wrote:

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?



Gord Dibben MS Excel MVP

Conditional Formatting of merged cells, borders don't show cor
 

I would be happy to forward the worksheet if you are interested.

"Gord Dibben" wrote:

I cannot replicate your problem.

CF colors and borders the merged cell as I ask it to.

Maybe a video card issue?

Or a printer driver issue?

Gord

On Thu, 21 Sep 2006 11:39:01 -0700, Pablo
wrote:

No, I want one conditional format to cover the entire merged cell. It has
worked in many places on the worksheet. In some places it only puts borders
around part of the merged cell. I have tried unmerging the cell and
remerging it and then placing the format formula on again with no luck.

"Gord Dibben" wrote:

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?



Gord Dibben MS Excel MVP

Conditional Formatting of merged cells, borders don't show cor
 

Forward to my email, not the group.

Replace the DOT and AT with appropriate characters.


Gord

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

I would be happy to forward the worksheet if you are interested.

"Gord Dibben" wrote:

I cannot replicate your problem.

CF colors and borders the merged cell as I ask it to.

Maybe a video card issue?

Or a printer driver issue?

Gord

On Thu, 21 Sep 2006 11:39:01 -0700, Pablo
wrote:

No, I want one conditional format to cover the entire merged cell. It has
worked in many places on the worksheet. In some places it only puts borders
around part of the merged cell. I have tried unmerging the cell and
remerging it and then placing the format formula on again with no luck.

"Gord Dibben" wrote:

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?



Gord Dibben MS Excel MVP