copy conditional formatting

[Guest]

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

Ajit

 

[Guest]

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!

 

[Gord Dibben]

You could use the Format Painter.

This is the paintbrush Icon on the formatting toolbar.

OR select A1 then the other cells and Format>CF>OK

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