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$100,C$22<""),
IF(ROW()=24,AND(C$101,C$24<""),
IF(ROW()=26,AND(C$102,C$26<""),
IF(ROW()=28,AND(C$102,C$28<""),
IF(ROW()=33,AND(C$160,C$33<""),
IF(ROW()=35,AND(C$161,C$35<""),
IF(ROW()=37,AND(C$162,C$37<""),
AND(C$163,C$39<"")
)))))))

Sandy