Conditional Formatting Based on Adjacent Cell

**Yourgurlwantsme** · 03-26-2010, 09:59 PM

I have a spreadsheet with three workbooks. The first workbook has two colums with a listing of artists in column A and corresponding songs in column B. In the second workbook I created formulas to snake the two columns into four. The formulas A-D are as follows:

=IF(Sheet1!A2="","",IF(Sheet1!A2=Sheet1!A1,"",Sheet1!A2))
=IF(Sheet1!B2="","",IF(Sheet1!B2=Sheet1!B1,"",Sheet1!B2))
=IF(Sheet1!A50="","",IF(Sheet1!A50=Sheet1!A49,Sheet1!A50&"(cont.)",Sheet1!A50))
=IF(Sheet1!B50="","",IF(Sheet1!B50=Sheet1!B49,"",Sheet1!B50))

This causes the Artist to only be displayed once and all that artists songs are listed in the next column. And, if the artists songs follow onto the following page, the artist's name is displayed again followed by (cont.).

Now I am trying to create an outline box around each artist and his/her songs. Can anyone help me with this?

**Yourgurlwantsme** · 03-26-2010, 10:14 PM

I would also like to create a macto that searches Sheet1 in order to find duplicate values in both Column A and Column B, delete those values, and move the remaining values up one space. I would have the macro delete the row, but when i have deleted rows in the past, the references to those cells on Sheet2 have been changed to #REF!.