Copying Conditional Format

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

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
 
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
 
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
 
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
Click to expand...
 
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
 
Back
Top