It cant be done other than using VB code. Search 'Excel Programming on
Google, there are loads of posts on this subject in there,
Regards,
Alan.
"Eqa" wrote in message
...
How do I increase the No. of formats in conditional formating from 3 to 6