A
alex1982
Is it possible to copy conditional formating to other cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marcelo
yes,
copy - paste special - formats
hth
regards from Brazil
Marcelo
"alex1982" escreveu:
copy - paste special - formats
hth
regards from Brazil
Marcelo
"alex1982" escreveu:
J
Jim May
Sure, You need to use the "Paint-Brush" Icon for that.
1st select the cell with the CF you like/want;
then click the Paint-Brush;
then either clcik the Destination cell (single-cell) you
wish to replicate the formating on or
Left-click and drag over multiple cells; release the
mouse and all will be painted.
HTH
1st select the cell with the CF you like/want;
then click the Paint-Brush;
then either clcik the Destination cell (single-cell) you
wish to replicate the formating on or
Left-click and drag over multiple cells; release the
mouse and all will be painted.
HTH
P
Paul Dusterhoft
Yes - just copy the cell which has the conditional format, then select the
other cells and use "paste special" and select "format".
other cells and use "paste special" and select "format".
A
alex1982
I have tried that but its not working how i want it to.
say if cells b2 to e2 are reffering to cell a2. if i copy and paste i
as u suggested cells b3 to e3 are still reffering to a2 not a3 as i wa
expectin
say if cells b2 to e2 are reffering to cell a2. if i copy and paste i
as u suggested cells b3 to e3 are still reffering to a2 not a3 as i wa
expectin
S
Sloth
you need to delete the "$" from the references in the conditional format
formula.
formula.
S
Sloth
just to clarify you need to change your reference from $A$2 to $A2. Then you
should be able to copy it.
should be able to copy it.