Copy Conditional Formatting
 

Hi ,

I have a row of cells with conditional formatting based ona couple of values.

Can i copy this formatting and paste to the other 30 or so rowns in the
worksheet ??

When i try i get the error message "you cannot change part of an array" ??

Copy Conditional Formatting
 

If it's possible, use the format painter (don't know if you can use it on an
array either).
http://www.officearticles.com/misc/f...oft_office.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"G" wrote in message
...
Hi ,

I have a row of cells with conditional formatting based ona couple of
values.

Can i copy this formatting and paste to the other 30 or so rowns in the
worksheet ??

When i try i get the error message "you cannot change part of an array" ??

Copy Conditional Formatting
 

Post the formula(s) that you're using for the CF.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"G" wrote in message
...
Hi Anne, yes this is what i am trying when i get the error...

"Anne Troy" wrote:

If it's possible, use the format painter (don't know if you can use it
on an
array either).

http://www.officearticles.com/misc/f...oft_office.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"G" wrote in message
...
Hi ,

I have a row of cells with conditional formatting based ona couple of
values.

Can i copy this formatting and paste to the other 30 or so rowns in
the
worksheet ??

When i try i get the error message "you cannot change part of an
array" ??

Copy Conditional Formatting
 

Hi Anne, yes this is what i am trying when i get the error...

"Anne Troy" wrote:

If it's possible, use the format painter (don't know if you can use it on an
array either).
http://www.officearticles.com/misc/f...oft_office.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"G" wrote in message
...
Hi ,

I have a row of cells with conditional formatting based ona couple of
values.

Can i copy this formatting and paste to the other 30 or so rowns in the
worksheet ??

When i try i get the error message "you cannot change part of an array" ??

Copy Conditional Formatting
 

D2 : N2 , various values in each cell.

Whole row has conditional formatting :

Condition 1, formula is : =AND($J$5<=tod,$J$5=$T$5)
Condition 2, formual is : =$J$5<$T$5

I want to take this and copy on to apporox next 30 rows withou affecting the
values currently inthese cells.

Thanks



"RagDyer" wrote:

Post the formula(s) that you're using for the CF.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"G" wrote in message
...
Hi Anne, yes this is what i am trying when i get the error...

"Anne Troy" wrote:

If it's possible, use the format painter (don't know if you can use it
on an
array either).

http://www.officearticles.com/misc/f...oft_office.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"G" wrote in message
...
Hi ,

I have a row of cells with conditional formatting based ona couple of
values.

Can i copy this formatting and paste to the other 30 or so rowns in
the
worksheet ??

When i try i get the error message "you cannot change part of an
array" ??

Copy Conditional Formatting
 

sorry one more suggestion
normally I do copy and pastespecial-formats work for in my excel 2000
but you speak of some array. if some array formula is used over a set of
cells and this cell is one ofthem it is different matter. you try to copy to
all the cells. if the conditins is not satisfied the conditional formatting
will not be invoked. (not tested-only a suggestion)

"RagDyer" wrote in message
...
Post the formula(s) that you're using for the CF.
--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"G" wrote in message
...
Hi Anne, yes this is what i am trying when i get the error...

"Anne Troy" wrote:

If it's possible, use the format painter (don't know if you can use it
on an
array either).

http://www.officearticles.com/misc/f...oft_office.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"G" wrote in message
...
Hi ,

I have a row of cells with conditional formatting based ona couple
of
values.

Can i copy this formatting and paste to the other 30 or so rowns in
the
worksheet ??

When i try i get the error message "you cannot change part of an
array" ??

Copy Conditional Formatting
 

Maybe your array formulas needn't be entered into a range.
Are they returning an "array" of values, or individual returns *from* an
array?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"G" wrote in message
...

D2 : N2 , various values in each cell.

Whole row has conditional formatting :

Condition 1, formula is : =AND($J$5<=tod,$J$5=$T$5)
Condition 2, formual is : =$J$5<$T$5

I want to take this and copy on to apporox next 30 rows withou affecting
the
values currently inthese cells.

Thanks



"RagDyer" wrote:

Post the formula(s) that you're using for the CF.
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"G" wrote in message
...
Hi Anne, yes this is what i am trying when i get the error...

"Anne Troy" wrote:

If it's possible, use the format painter (don't know if you can use
it
on an
array either).


http://www.officearticles.com/misc/f...oft_office.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"G" wrote in message
...
Hi ,

I have a row of cells with conditional formatting based ona couple
of
values.

Can i copy this formatting and paste to the other 30 or so rowns
in
the
worksheet ??

When i try i get the error message "you cannot change part of an
array" ??