Copy Conditional Formatting

G

G

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

G

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
 
R

RagDyer

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