Conditional Formatting allows 3 conditions......4 if you count default.

John McGimpsey shows how to get 6 font colors if the data is numeric.

http://www.mcgimpsey.com/excel/conditional6.html

Other than that, you must use VBA code.

On the other hand, if you mean by more than 3 instances, can you apply to more
than three cells, yes you can.

Re-post with a description of your needs in the body of your post.

Hard to get a feel for that when the subject header is truncated.


Gord Dibben Excel MVP

On Tue, 20 Dec 2005 17:07:02 -0800, Mary jane
wrote: