Too many characters in formula?
 

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

Too many characters in formula?
 

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 InsertNameDefine
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.

--
Biff
Microsoft Excel MVP


"Sandy" wrote in message
...
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