Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MMAC
 
Posts: n/a
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting to multiple cells TC Excel Worksheet Functions 6 January 7th 06 11:41 PM
Conditional Format Not Working KMH Excel Discussion (Misc queries) 0 December 22nd 05 05:32 PM
Use functions when cells are merged Amanda Excel Worksheet Functions 3 September 12th 05 06:08 PM
Sorting Area with Merged Cells prizm1 New Users to Excel 3 September 10th 05 11:49 PM
Conditional format problem PJ Excel Discussion (Misc queries) 2 March 11th 05 02:05 PM


All times are GMT +1. The time now is 08:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"