=if(or(cond1,cond2),true,false) and
if(and(cond1,cond2),true,false)
are definitely acceptable

if you're having a hard time getting your conditions to work just post
what the conditions you're wanting to format are and i'm sure someone
will be able to make it fit into three rules


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563452