Sort-of.

Select all the cells you want formatted (using Shift and/or Ctrl to select
discontinuous ranges) and then select the cell with conditional formatting
you want to copy. With the "source" cell being active, go into your
conditional format rules.

If its visible (which means the destination cells have no format already
applied)
Simply hit "Ok", and that format will be applied to all the cells.

If the rules appear blank, you can either re-create the rule, or go back and
first remove the conditioning from the 'destination' cells.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Art" wrote:

Is there a way to copy and paste ONLY the conditional formatting settings? In
other words I don't want the destination cells to acquire all the other
formats (borders, font size, etc) of the source cell.
--
Art