Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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" ?? |
#2
|
|||
|
|||
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" ?? |
#3
|
|||
|
|||
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" ?? |
#4
|
|||
|
|||
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" ?? |
#5
|
|||
|
|||
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" ?? |
#6
|
|||
|
|||
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" ?? |
#7
|
|||
|
|||
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" ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions |