Is there a conditional format formula complexity limit?

[paulkinzelman]

I'm trying to conditionally format (Excel 2000) a cell and it's not working, any help or pointers would be appreciated.

My formula is AND(B10<l9,or(a9=a10,l9<b9,e9<b9,l9<e9))

I can put each comparison in a separate cell and they all work correctly.

I can even put that whole formula in a cell and it evaluates correctly (to true).

I can even conditionally format a cell with a trivial formula that merely points to the cell containing the above evaluation (to true) and it works.

But when I make the conditional format actually be this formula, it doesn't work, the color does not change as I specify.

I've noticed this once before with another similarly complex formula, but just punted.

Is there some maximum limit to nestings or length or something in conditional formatting?

Thanks!</l9,or(a9=a10,l9<b9,e9<b9,l9<e9))

 

[Marcelo Branco]

... but Marcelo Branco wins the prize of rescuing me from my stupidity.

As I had already had the same problem so I knew what to do.

Remember the old saying.
All things are difficult before they are easy.

Thanks for the feedback.

M.

 

[Alatel]

I'm not sure this is the correct thread for this post but as the question is the same here goes.
I am trying to get excel to conditionally format a cell if certain conditions exist .
The following formula works when entered into a cell in the spreadsheet BUT does nothing when entered into conditional formatting formula to format a cell depending on a formula.

=IF(NOT(AND(OR(A23=""na"",A23=""np"",A23=""u""),AND((LEN(A27)>10),(ISNUMBER(NUMBERVALUE(LEFT(A27,4))))))),""b4"",""c4"")

the formula checks that
Cell a23 contains either na, or np or u
Cell a27 entry has more than 10 characters and first 4 are numbers.
I want to extend the formula but this first part does not want to work when used in conditional formatting.
I could enter the formula into a cell then reference the result in the conditional formatting formula and it will work BUT !!! I don't want to do this, I would prefer to enter the formula into the conditional formatting rule.
Any assistance will be greatly appreciated
Cheers
Alan