No, not when used if CF. If it were a cell formula then yes, it would be a
circular reference.
I tried this last night and it worked! The same formula less the COUNT
portion. I did this in a reply to a post in the .misc group.
Biff
"Toppers" wrote in message
...
Biff,
Won't the INDIRECT part produce a circular reference (or have I
completely misunderstood how the CF is applied.... not for the first
time!!!). If so, it won't work.
"T. Valko" wrote:
P.S.
I know this can be done with different formulas. Please don't offer other
formulas. I want to know why *this* formula isn't working!
Thank you
Biff
"T. Valko" wrote in message
...
This has me completely stumped!
Why doesn't this conditional formatting get applied?
Screencap:
http://img522.imageshack.us/img522/8...problembt4.jpg
The formula is correct. I've put the same formula in column O (adjusted
for the column offset) and as you can see, evaluates to TRUE.
That highlighted 23 is also conditionally formatted. Just a test to
make
sure that *any* CF is working.
Thanks
Biff