kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hi,
I am looking for a way to place borders around my cells in a unique way.
So my range is B2:J16 with columns E and H excluded.
So like in cell B2 and C2 we have same items "B" and "B" so we have the border around the range B2:C2 with no line in between B2 and C2. That's we show only border outline. Then in cell D2 since E2 is excluded we set border for only the D2 .
Then we continue in that order.
So we may have something like this :
I am looking for a way to place borders around my cells in a unique way.
So my range is B2:J16 with columns E and H excluded.
So like in cell B2 and C2 we have same items "B" and "B" so we have the border around the range B2:C2 with no line in between B2 and C2. That's we show only border outline. Then in cell D2 since E2 is excluded we set border for only the D2 .
Then we continue in that order.
So we may have something like this :
Code:
[COLOR=#333333]|Col B |Col C |Col D |Col E |Col F |Col G |Col H |Col I |Col J|
---------------------------------------------------------------------------------------
| B B | G | | G | I | | A | A |
--------------------------- --------------------- ------------------
| A A | E | | D D | | F | F |
--------------------------- --------------------- ------------------
| I I | F | | A A | | C C |
--------------------------- --------------------- ------------------
| H | C C | | B | H | | D D |
--------------------------- --------------------- ------------------
| B | D | H | | E E | | F | A |
--------------------------- --------------------- ------------------
| I | B | G | | G | D | | C C |
--------------------------- --------------------- ------------------
| A A | E | | D D | | F F |
--------------------------- --------------------- ------------------
| I I | G | | A A | | C C |
--------------------------- --------------------- ------------------
| H | C C | | B | H | | D D |
--------------------------- --------------------- ------------------
| I | D | H | | E E | | B | A |
--------------------------- --------------------- ------------------
| B B | G | | G | I | | C C |
--------------------------- --------------------- ------------------
| A A | E | | D D | | F F |
--------------------------- --------------------- ------------------
| I I | G | | A A | | C C |
--------------------------- --------------------- ------------------
| H | C C | | B | H | | D D |
--------------------------- --------------------- ------------------
| B | D | H | | E E | | F | A |
---------------------------------------------------------------------------------------[/COLOR]