copy conditional formatting
 

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

Ajit

Hi Ajit,

Use the format painter(paint brush icon).
Select the cell that has the desired cond. formatting,
then press the format painter(double click if copying format to 2+ cells),
select the cell(s) that you want the same cond. formatting applied to.

Have a great day!
--
Kevin Lehrbass
www.spreadsheetsolutions4u.com


"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

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