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

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

David McRitchie offers a solution : When Conditional Formatting needs
more than three Formatting groups per cell.

http://www.mvps.org/dmcritchie/excel/event.htm#case

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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