Re: Data entered needs to cover 2 vertical cells

Another option would be to enter the delivery address in each row, and then use conditional formatting to hide the duplicates.

To copy the entry from the line above, the keyboard shortcut is Ctrl+'
I wouldn't use formulas to link to the address above, because that could cause problems if you sorted the list.

To add the conditional formatting, assuming the delivery address is in column B:

Select the cells, from B2, down to the last address (B2 is the active cell, and its address is in the Name box, to the left of the Formula bar)
On the toolbar, click the dropdown arrow for borders, and click All Borders
Choose Format>Conditional Formatting
From the first dropdown, choose Formula
In the formula box, type: =AND(B2=B1,B2=B3)
Click Format, and select White font colour, and on the Border tab, remove the top and bottom border, then click OK

Click Add, to create a second condition
From the first dropdown, choose Formula
In the formula box, type: =AND(B2=B1,B2<>B3)
Click Format, and select White font colour, and on the Border tab, remove the top border, and add sides and bottom border, then click OK

Click Add, to create a third condition
From the first dropdown, choose Formula
In the formula box, type: =AND(B2=B3,B2<>B1)
Click Format, and do not select a font colour, and on the Border tab, remove the bottom border, and add sides and top border, then click OK


The Little Mermaid wrote:
Could I please get some help with the following little problem I have?
I need to enter an address that will cover 2 vertical cells while leaving the cells either side as 2 separate cells. For example, reading from left to right across the work*** - 1st 2 vertical cells different company’s name, next cell same delivery address, (this is the one I want as one cell) 3rd cell telephone numbers separate cells.
Many thanks in advance.
Kind regards,
Dawn



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.