Try this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90
*******************
~Anne Troy

www.OfficeArticles.com


"doran_doran"
wrote in message
...

can you have more than 3 conditional formating. if yes, how ? btw, i am
using excel 97. thanks


--
doran_doran
------------------------------------------------------------------------
doran_doran's Profile:
http://www.excelforum.com/member.php...o&userid=25274
View this thread: http://www.excelforum.com/showthread...hreadid=387677