Too many characters in formula?

[Sandy]

Excel 2003
I have a series of rows with conditional formatting and I am trying to
prevent the formatting from being altered if the rows are copied.
The following is not accepted in conditional formatting because I think
there are 259 characters (I am guessing that 256 is maximum).

So....
Is there any way to shorten the following?

=IF(ROW()=22,AND(C$10>0,C$22<>""),
IF(ROW()=24,AND(C$10>1,C$24<>""),
IF(ROW()=26,AND(C$10>2,C$26<>""),
IF(ROW()=28,AND(C$10>2,C$28<>""),
IF(ROW()=33,AND(C$16>0,C$33<>""),
IF(ROW()=35,AND(C$16>1,C$35<>""),
IF(ROW()=37,AND(C$16>2,C$37<>""),
AND(C$16>3,C$39<>"")
)))))))

Sandy

 

[T. Valko]

The length limit in a refedit (that little box where you enter the formula)
is 255 chars.

I can't tell what you're trying to do but to get your current formula to
meet the length limit try using a defined name and replace the ROW()
function with this defined name.

Goto the menu Insert>Name>Define
Name: RO
Refers to: =ROW()
OK

Then replace every instance of ROW() in the formula with RO. That'll get the
formula length down to 238 chars.