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