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