Copying Conditional Format

[Robin Chapple]

Is it possible to copy conditional formatting that is already applied
to a given cell to another cell?

I know that the format is held and continuous formatting is possible,

Thanks,

Robin Chapple

 

[JulieD]

Hi Robin

you can copy and paste formatting (including conditional formatting) using
either the format painter (big yellow paintbrush toolbar icon) - click on
the cell with the formatting, click on format painter, click on the cell
where you want the formatting "painted" (double clicking on the format
painter turns it on until you turn it off)
or by using copy and then edit / paste special - formats

cheers
JulieD

 

[Gord Dibben]

Robin

If the CF is a result of "Formula is:" just make sure your absolute and
relative cell references are correct for the occasion.

Gord Dibben Excel MVP

 

[Robin Chapple]

Thanks to both,

Robin

Hi Robin

you can copy and paste formatting (including conditional formatting) using
either the format painter (big yellow paintbrush toolbar icon) - click on
the cell with the formatting, click on format painter, click on the cell
where you want the formatting "painted" (double clicking on the format
painter turns it on until you turn it off)
or by using copy and then edit / paste special - formats

cheers
JulieD

 

[Guest]

If you haven't already...
Read "Duplicate row's formatting" discussion found in "Excel New Users"
The solution so simple.

the $ simble locks the column and/row that it preceeds. Look in your
initial formattin. Take out the $ where you want the info to change
respective to the cell.

Did that make any sense?

I tried.
Cora