ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional format in merged cells. (https://www.excelbanter.com/excel-discussion-misc-queries/75431-conditional-format-merged-cells.html)

MMAC

Conditional format in merged cells.
 
Hi guys,

Who can help me out?
I used conditional format in a cell. Later I merged the cell with
another one. The color appears in the whole merged cell; the border
only in the left part (the original first cell). Removing the
conditional format and applying it again doesn't help.
Who knows how to solve this problem?
Thanks in advance.

Mieke.



Conditional format in merged cells.
 
Hi
I have done what you have posted - and redoing the CF works for me (Excel
2K).
I got the same result as you after merging the cells, then I cleared the CF,
and then I redid it and it's fine.

Andy.

"MMAC" wrote in message
oups.com...
Hi guys,

Who can help me out?
I used conditional format in a cell. Later I merged the cell with
another one. The color appears in the whole merged cell; the border
only in the left part (the original first cell). Removing the
conditional format and applying it again doesn't help.
Who knows how to solve this problem?
Thanks in advance.

Mieke.





All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com