You could use the Format Painter.

This is the paintbrush Icon on the formatting toolbar.

OR select A1 then the other cells and FormatCFOK

The CF will be carried over to the other cells.

Note: if a formula, make sure you have the references properly set using the $
signs(s)


Gord Dibben Excel MVP

On Thu, 29 Sep 2005 03:44:02 -0700, ajitbmunj
wrote:

1. I want to copy the conditional formatting set to cell A1 to Cell B1, C1,
D1..K1.How can I do so?

Ajit