Conditional Formatting - Using AND Formula

[rsbrunton]

Problem
When extending conditional format formula to use AND(), formatting is not applied

Example Using Excel 2007
Cell A1:
Contains formula "=INDIRECT(ADDRESS(ROW(),2))=100"
Conditional Formatting set to fill color to Green if "=INDIRECT(ADDRESS(ROW(),2))=100"
Cell B1:
Contains value of "100"
--> Result: A1 evaluates to TRUE and fill color is Green ... cool!

Cell A2:
Contains formula "=AND(INDIRECT(ADDRESS(ROW(),2))=100,TRUE)"
Conditional Formatting set to fill color to Green if "=AND(INDIRECT(ADDRESS(ROW(),2))=100,TRUE)"
Cell B2:
Contains value of "100"
--> A2 evaluates to TRUE, but fill color is not Green ... doi!

Cell A3:
Contains formula "=AND(TRUE,TRUE)"
Conditional Formatting set to fill color to Green if "=AND(TRUE,TRUE)"
--> A3 evaluates to TRUE, and fill color is Green ... cool!

What am I missing here?
Are there issues of formula complexity within Conditional Formatting?
Online documentation of other nuances anywhere?

My thanks in advance.

 

[Jonmo1]

Glad to help, thanks for the feedback..

I wouldn't call it a bug though, more like a limitation.

 

[Jerry Sullivan]

Glad to help, thanks for the feedback..

I wouldn't call it a bug though, more like a limitation.

jonmo1,

You're kind!

I don't know the formal definition of a Bug, but to me a Limitation is something that is known and documented like the inprecision of floating-point arithmetic.

Perhaps we can say this is a Limitation because it's documented in this thread on the MrExcel Forum?