Good afternoon Martc
You can download a free add-in called CFPlus which will handle thirty
formats. Not being a fan of conditional formatting I have never
actually used it, but if you do decide to try it please post back your
thoughts as this question crops up constantly...
http://www.xldynamic.com/source/xld.....Download.html
HTH
DominicB
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=380823