foolonthehill
New Member
- Joined
- Jun 7, 2011
- Messages
- 1
I've been happily using the much improved conditional formatting that arrived with Excel 2007, but having just upgraded to 2010 it seems to have been broken again.
I have conditional formats that remove the borders (defined using a cell style) from a small number of cells within a large column. In Excel 2007, this removed the borders from the cells I wanted, leaving the rest as "blocks" of cells, each with their own borders, exactly as I want.
In 2010, the conditional format overrides the neighbouring cell's border and deletes it, leaving each "block" without a top and a bottom border. Is this intended behaviour?
It seems to me to be a step backwards: in xl2007 each cells has its own 4 borders, but in xl2010 every cell now shares every border with its neighbouring cells.
Thanks for any input.
******** src="" style="width:0; height: 0; visibility:hidden;" name="pawIframe">*********>******** src="" style="width:0; height: 0; visibility:hidden;" name="pawIframe">*********>
I have conditional formats that remove the borders (defined using a cell style) from a small number of cells within a large column. In Excel 2007, this removed the borders from the cells I wanted, leaving the rest as "blocks" of cells, each with their own borders, exactly as I want.
In 2010, the conditional format overrides the neighbouring cell's border and deletes it, leaving each "block" without a top and a bottom border. Is this intended behaviour?
It seems to me to be a step backwards: in xl2007 each cells has its own 4 borders, but in xl2010 every cell now shares every border with its neighbouring cells.
Thanks for any input.
******** src="" style="width:0; height: 0; visibility:hidden;" name="pawIframe">*********>******** src="" style="width:0; height: 0; visibility:hidden;" name="pawIframe">*********>
