View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default conditional formatting problem

Biff,

When I enter numbers into the Address function, it works, but doesn't when I
use ROW() and/or COLUMN().

Perhaps it is too nested for CF.

Bernie


"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