Formatting on more than 3 conditions

[Martin]

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

 

[Tom Ogilvy]

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.

 

[pfsardella]

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