Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |