| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Merged Cells | Excel Worksheet Functions | |||
| counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Hybrid Mode
