Conditional Formatting Questions
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.
|