Conditional formatting only supports 3 conditions (+ 1 for the default,
anything else).

If you need more, check out Take a look at this site:
http://xldynamic.com/source/xld.CFPlus.Download.html


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mostafa Niazy" <Mostafa wrote in message
...
I have used the conditional sum wizard for many times , but i found that
if
you give
it mare than 4 conditions and the database in a differnet sheet , after
you
finish
and press Enter you found the cell is blank with no error