Conditional Formatting Questions

[Warminster]

I have a list where column A is the category type. Each line lists the category type. When the category changes, I need a line to be drawn between the two categories. I've set up a conditional format uses the formula

=NOT($A2=$A1)

to distinguish where the current cell differs from the cell above and to apply a top border to the cell. This effectively draws a line between categories. I've copied this format over to the columns to the right and it draws the line correctly.

However, I have a column that has existing color highlights. When I try to copy this conditional format to the column, it pastes over the other color formatting as well.

I have two questions.

1) How can I paste only conditional formatting and leave all the other formatting intact?

2) How can I convert conditional formatting into standard formatting? I.e. I want to leave the results of the conditional formatting intact, but have the format actually no longer be conditional.

[Zack Barresse]

1) copy -> paste special -> formats.

2) i have no idea! that would be cool though!

hth

[Warminster]

Unfortunately when I use "copy -> paste special -> formats" it pastes the color from the column I am copying, which has no color. This erases the existing color formatting that exists in the cell.