Take at look at these pages, they might help

http://www.xldynamic.com/source/xld.CF.html

and

http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kang" wrote in message
...
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.