Conditional Formating
 

Is it possible to copy conditional formating to other cells?


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516

Conditional Formating
 

yes,

copy - paste special - formats

hth
regards from Brazil
Marcelo

"alex1982" escreveu:


Is it possible to copy conditional formating to other cells?


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516

Conditional Formating
 

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



"alex1982" wrote:


Is it possible to copy conditional formating to other cells?


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516

Conditional Formating
 

Yes - just copy the cell which has the conditional format, then select the
other cells and use "paste special" and select "format".
"alex1982" wrote in
message ...

Is it possible to copy conditional formating to other cells?


--
alex1982
------------------------------------------------------------------------
alex1982's Profile:
http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516

Conditional Formating
 

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 it
as u suggested cells b3 to e3 are still reffering to a2 not a3 as i was
expecting


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516

Conditional Formating
 

you need to delete the "$" from the references in the conditional format
formula.

"alex1982" wrote:


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 it
as u suggested cells b3 to e3 are still reffering to a2 not a3 as i was
expecting


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516

Conditional Formating
 

just to clarify you need to change your reference from $A$2 to $A2. Then you
should be able to copy it.

"Sloth" wrote:

you need to delete the "$" from the references in the conditional format
formula.

"alex1982" wrote:


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 it
as u suggested cells b3 to e3 are still reffering to a2 not a3 as i was
expecting


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571516