conditional formatting is so confusing.
especially "using formula".
in the box for "format when the next formula is true"
what format can be?
I want to know the mechanism.
Thanks.
Take at look at these pages, they might help
http://www.xldynamic.com/source/xld.CF.html
and
http://www.contextures.com/xlCondFormat01.html

Signature
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
> conditional formatting is so confusing.
> especially "using formula".
[quoted text clipped - 4 lines]
>
> Thanks.