3 is the limit. (plus the basic format of the cell).

Beyond that you would have to write an event related macro to do the
formatting.

--
Regards,
Tom Ogilvy


Martin wrote in message
...
Can anyone tell me the best way to apply conditional
formatting to more than three conditions. I have searched
the knowledge base and cannot find anything on this.

Please please somebody help!!

Thanks,

Martin