Conditional Formating-Is it possible to copy conditional formating to other cells?

Is it possible to copy conditional formating to other cells?

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
>
>

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
>
>

Yes - just copy the cell which has the conditional format, then select the
other cells and use "paste special" and select "format".
"alex1982" <alex1982.2cjobu_1155583508.4551@excelforum-nospam.com> wrote in
message news:alex1982.2cjobu_1155583508.4551@excelforum-nospam.com...
>
> 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
>

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

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
>
>

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
> >
> >