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