CF is different from a worksheet cell formula. The formula used in CF does
not actually reside in the cell like a worksheet formula.

Biff

"CK" wrote in message
...
Now I understand. But the interesting thing is, the formula

=INDIRECT(ADDRESS(ROW(),COLUMN()))0

actually works in conditional formatting.

"T. Valko" wrote:

This part of the formula creates the circular reference:

INDIRECT(ADDRESS(ROW(),COLUMN()))0

It refers to the cell that the formula is in thus being a circular
reference.

Biff

"CK" wrote in message
...
Try copy and paste this to anywhere in a blank worksheet:

=AND(INDIRECT(ADDRESS(ROW(),COLUMN()))0,INDIRECT( ADDRESS(18,COLUMN()))=TRUE)

On my machine, Excel keeps saying this is a circular reference. Can
anyone
explain to me why?