Copy ONLY the conditional part of a cell format?

[gardnertoo]

Is there a way to copy only the conditional part of the cell formatting from one cell to another, without disturbing the underlying "unconditional" formatting? Using the format paint tool replaces both the conditional formats and the normal formats in the target cell. For example, I have cells in several columns to which I want to apply the same conditional format, but each column has it's own number format and font / color / background settings that I want to keep. What I'm doing now is create the conditionals, copy it across, then manually redo the formats in each cell in the row. Then I use the format paint tool to apply the formatting down to the rows below. Is there a better way?

 

[Xedoc]

Hmmm, here is what I'd do. Delete all cond format from all cells except your source, then select all your cells and make sure the source cond. format is in the active cell, then apply to the whole range.

Does it make sense?

 

[gardnertoo]

Of course! Thank you for that. I've done that before, should have remembered that.

John